Macro to Transfer data from multiple sheets into rows on a master sheet

**serrone** · 03-29-2013, 08:52 PM

Hello,

I have an enormous amount of data that I need to consolidate into a master sheet in excel for statistical analysis. In the following example I need to transfer A1:X1 in this sheet to I5:I28 in the master sheet, A2:X2 in this sheet to I29:I52 in the master sheet, A3:X3 in this sheet to I53:I76 in the master sheet etc.

So the final result would lay out data for this single sheet into one row on the master sheet. Thank you in advance for any help.

Regards
Joe

excel example.jpg

**luv2glyd** · 03-29-2013, 10:30 PM

Welcome to the forum. I do these kind of manipulations all the time - basically what you want to do, is start to record a macro in the main sheet and do your operation 3 times - copy from data sheet, paste transpose to main sheet, repeat (this will also teach you how VBA works so you can do this easily in the future), look at the code and set it on a repeating loop till it's done. Try doing that and attach both of your sheets in the next post including the macro you've recorded. I can help you with the loop. You can do the above with "dummy sheets" that have fake data if you are not comfortable posting the real ones.

**serrone** · 03-30-2013, 12:19 AM

That works very well and is quick. I'll continue to play around with recording macros and see if I can make it smoother. Thanks for your time. This was very helpful.

Joe