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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate Data from Summary Sheet 5
Help to create a macro 2
Copying from different files into 1 1
Summary sheet from tab names 3
Excel Move or Copy Stopped Working? 0
Possible? Copy/paste to&from moving sources/destinations 2
Summary Worksheet. 1
data to summary sheet for a dummy 0

Back
Top