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

Sheila

"Glissader" wrote:

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