0
Undo
Votes
Struggling with how to explain this so bear with me plz...
I have multiple workbooks with the same basic set of sheets in them. Each sheet is named the same for each workbook. While using the Combine feature for 'like named' sheets, I can get it to grab each sheet from each workbook and combine them into one set of sheets in one workbook.
The issue I am having is each set of sheets may not have the exact same number of columns in it. Sheet1 in WB1 may have 12 columns and sheet1 in WB2 may have 10 columns. The function is combining the sheets and listing all 12 columns but at some point when it moves from one workbook to the next, the data ceases to line up in the correct columns.
Thoughts on what I am missing?
Visual to help explain what I am seeing
WB1:Sheet1
WB2:Sheet1 (no Column3/Data3)
Desired State:
CombinedWB:Sheet1
Actual State:
CombinedWB:Sheet1
I have multiple workbooks with the same basic set of sheets in them. Each sheet is named the same for each workbook. While using the Combine feature for 'like named' sheets, I can get it to grab each sheet from each workbook and combine them into one set of sheets in one workbook.
The issue I am having is each set of sheets may not have the exact same number of columns in it. Sheet1 in WB1 may have 12 columns and sheet1 in WB2 may have 10 columns. The function is combining the sheets and listing all 12 columns but at some point when it moves from one workbook to the next, the data ceases to line up in the correct columns.
Thoughts on what I am missing?
Visual to help explain what I am seeing
WB1:Sheet1
Column1 | Column2 | Column3 | Column4 |
Data1 | Data2 | Data3 | Data4 |
WB2:Sheet1 (no Column3/Data3)
Column1 | Column2 | Column4 |
Data1 | Data2 | Data4 |
Desired State:
CombinedWB:Sheet1
Column1 | Column2 | Column3 | Column4 |
Data1 | Data2 | Data3 | Data4 |
Data1 | Data2 | | Data4 |
Actual State:
CombinedWB:Sheet1
Column1 | Column2 | Column3 | Column4 |
Data1 | Data2 | Data3 | Data4 |
Data1 | Data2 | Data4 | |
- Page :
- 1
There are no replies made for this post yet.