Hi

- can anyone help?

I have two sheets (1 & 2) within an excel file and I wish to run a macro to pull the results of sheet 1 into the other, sheet 2.

Sheet 1 may vary in size & length so I want to copy all of the used-range(?) but move down the text following so that it is beneath the inserted sheet.

I attach an example of the sheets and an end result sheet.

My knowledge of macros is very limited

Thanks