Custom Paste

[ChrisRocks]

Hi there,

I am working on a excel file to help me interpret survey data. I am having some problems transposing data from tab1 to tab2. I was wondering if there is a macro or anything to help.

So basically, I need all the data from Z on tab1 to be transposed on individual lines on tab2, attached.

Thanks in advance.
Chris

[mdbct]

Quick questions:
Are there always only 5 responses or can the number be variable?
Is the Total summary always present?

[ChrisRocks]

There will always be 5 responses. The Total Summary is always present.

[mdbct]

Try this one. The macro would accommodate any number of responses - up to the number of columns on your spreadsheet. (macro was designed before I saw your response)

The macro currently requires a sheet called Summary. Change the text in blue to either the correct name or number of the sheet where you want the data moved.
Syntax for the number of the sheet would be Worksheets(2) <this would be the second sheet in your book

Please Login or Register  to view this content.

[ChrisRocks]

I don't understand it, but thank you very much it works perfectly!

You Rock!

[mdbct]

Glad I could help. Don't forget to mark your thread as "Solved"