Hi,

I need a macro that will copy a set of vertical data e.g. range A7:A25 from
a sheet called "PASTE TX HERE" and transpose paste it in the next free row
down (starting with row 2 on a sheet called "Leaver Master".

I need this to run at the end of a macro I have already written so please
give me some advice on where variable declaration should go or if there is a
code that I can put at the end of my macro to initiate the macro I hope you
can provide.

Thanks in advance.

JohnP