Different read ranges

Help
1

I can use the Read Range Activity to read this range: “A5:F61”

However, the range might vary for different files like “A5:F83”. Is there a way I dont have to default it?

2

Hi @qaz1

If you use "" it will take the entire working range.

You could then delete the first few rows that you don’t need.

3

Just to inform you, I am using a pivot table… so the first few lines are the filters! I cannot delete them.
Secondly, the when I use “” the formatting would be off when I have to input formulas on a new column.

1 Like
4

Hi @qaz1, you could just use “A5”. It will read from A5 till the end.

Cheers.

2 Likes
5

Thank you!!

1 Like
6

No worries, happy automation :slight_smile: