First, thank you in advance for taking your time to help me.
I have Excel workbook which can have over 111 worksheets. What i am trying to do is to consolidate some of the information into a single worksheet and have the rows of data transposed into columns.
In each worksheet, rows 1 to 5 would contain data in column A. Rows 6 to 8, the data is in column B.
Is there a way (macros) to consolidate all the data into one single workbook where the data from the individual worksheets would be transposed as columns?
Worksheet1 rows 1 to 8 would be transposed across Consolidated worksheet columns A2-H2
Worksheet2 rows 1 to 8 would be transposed across Consolidated worksheet columns A3-H3
Worksheet3 rows 1 to 8 would be transposed across Consolidated worksheet columns A4-H4
etc., etc.
Thank you again for your help!
Jan
I have Excel workbook which can have over 111 worksheets. What i am trying to do is to consolidate some of the information into a single worksheet and have the rows of data transposed into columns.
In each worksheet, rows 1 to 5 would contain data in column A. Rows 6 to 8, the data is in column B.
Is there a way (macros) to consolidate all the data into one single workbook where the data from the individual worksheets would be transposed as columns?
Worksheet1 rows 1 to 8 would be transposed across Consolidated worksheet columns A2-H2
Worksheet2 rows 1 to 8 would be transposed across Consolidated worksheet columns A3-H3
Worksheet3 rows 1 to 8 would be transposed across Consolidated worksheet columns A4-H4
etc., etc.
Thank you again for your help!
Jan