How can i copy data from a tabbed working sheet to a summary sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have cells in worksheets sheets Jan to Dec stored in columns that I wish to
have copied across to a summary sheet and store them in rows.

Is it possible to do this?
 
Select the range to copy
Edit|copy

Select the top left corner of the range to paste
Edit|paste special|click the transpose button.
 
Back
Top