Help in transferring data from one sheet to another..

T

TechnoGram

I have set up a table with the first row holding labels every 6 cells
and below row 2 contains headings row over 2 columns of data under
each label.
I now wish to find a way to transfer this information to another sheet
set up in a different layout with the data running in rows with the
labels from sheet one running down column one.
I hope I am making sense as I am fairly new to this
thanks in advance for help
 
G

Gord Dibben

Play around with Edit>Copy and Edit>Paste Special>Transpose

Notes..........if running <2007 version you are limited to 256 to transpose to
columns. Also you cannot overlap any existing data.


Gord Dibben MS Excel MVP
 

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

transferring data to new multiple spreadsheets 1
Excel Help to copy information from one row at a time to another sheet 1
Copy Data from One sheet to Different Sheets 1
How do I move entire row from one excel sheet to another 3
Pulling data from one sheet to another 1
moving rows to another sheet 3
Get Name of Sheet to use in Macro 11
***Help on writing a vba code 12

Top