Paste range should be dynamic range

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…

Can you be more clear?

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.

Use append range it will append your data to main sheet

1 Like