Paste range should be dynamic range

Help Studio
1

I try to copy from excel file and paste the data should be blank rows (after available rows)

i.e Paste data can be row A10 or A14 and etc…

2

Can you be more clear?

3

I have large no. of excel file which contains multiple rows of data which we can say that consolidation sheet.

I try to copy data from ‘sheet1’ and paste in to consolidation sheet in last rows (last rows is dynamic rows). pls help me and fix.

4

Use append range it will append your data to main sheet

1 Like