Transpose specific row of multiple sheets into one single sheet using VBA

Hi All,

I'm a newbie in vba and looking to consolidate a specific row of data from multiple sheets into a single sheet for my project.

the specific rows are on Row 27, Column C to AL. The code shall loop such that data from all the sheets in these range are transposed into the new sheet like the following.



sample.jpg

Appreciate if someone could help me out. Thanks in advance.

Originally Posted by stnkynts

Submit an example workbook

below i have attached an example workbook. im looking for the code to help me in getting the results as in the compiled sheet.

Help on the above anyone?

Originally Posted by alansidman

Try this:

Please Login or Register  to view this content.

Thanks Alan! That was really helpful in processing tons of the data I have. Works like a charm!