View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnP JohnP is offline
external usenet poster
 
Posts: 22
Default 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