Boomer1962
New Member
- Joined
- Jul 4, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
This is my first post so please bear with me. I have only a little experience with VBA coding.
I have no coding done so far because I do not know where to start.
I have workbooks containing one sheet of data only. I will be opening these one by one and performing the extract before moving to the next one.
All the worksheets are laid out the same way but, the number of columns varies from one to the next. The first 2 title columns contain store number and name in rows. The intermediate columns contain a varying number of "sizes" and some "sizes" may repeat with the quantities per store as data below that. The last columns are totals. The number of totals columns can vary from 1 to ?? depending on unique values in the intermediate column headers. The totals columns group together all columns with the same "sizes" and the data in those columns is the sum of all the columns with the same sizes.
I need to extract the totals columns one at a time into a separate workbook (let's call this workbook the "Summary"). The "Summary" workbook is arranged "transposed" meaning that each column's data from the source workbook will add a row to the "Summary" workbook.
First I need to find the position of each Totals column and copy. Then I need to paste "transposed" into the destination row.
I understand this is a big ask but any examples to guide me would be of help.
Thank you
I have no coding done so far because I do not know where to start.
I have workbooks containing one sheet of data only. I will be opening these one by one and performing the extract before moving to the next one.
All the worksheets are laid out the same way but, the number of columns varies from one to the next. The first 2 title columns contain store number and name in rows. The intermediate columns contain a varying number of "sizes" and some "sizes" may repeat with the quantities per store as data below that. The last columns are totals. The number of totals columns can vary from 1 to ?? depending on unique values in the intermediate column headers. The totals columns group together all columns with the same "sizes" and the data in those columns is the sum of all the columns with the same sizes.
I need to extract the totals columns one at a time into a separate workbook (let's call this workbook the "Summary"). The "Summary" workbook is arranged "transposed" meaning that each column's data from the source workbook will add a row to the "Summary" workbook.
First I need to find the position of each Totals column and copy. Then I need to paste "transposed" into the destination row.
I understand this is a big ask but any examples to guide me would be of help.
Thank you