Copy and transpose paste
 

Hi,

I need to get a macro to copy a vertical set of data from one worksheet at a
time onto a master sheet (which is on the same workbook and shouldn't be
copied from), pasting horizontally on the next free row down, starting with
the second row.

Also, the shell of a macro that will loop code that I have written so that
it is carried out on one worksheet at a time on an undefined number of
worksheets. This would need to work for all sheets except the master sheet.

Let me know if you need any more information. Thanks in advance for any
ghelp you can offer.

John P