Copying worksheet but changing format

G

Glissader

Is it possible to copy one worksheet into a new one but switch the headings
to be on the left vertical and vice versa? Or must I manually recreate the
whole worksheet in this new set-up?

Thanks
 
S

Sheila D

I think you probably need Paste Special and Transpose which takes headings
from Row and puts in column or vice versa. HTH

Sheila
 
Top