If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Consolidating multiple workbooks with several tables
I have a lot of evaluation sheets I want to consolidate into one master sheet.
In every workbook only one sheet is used, same cells are used throughout but they are split up into several tables with different headlines. Ex: Row 4 - title Row 5, text in cell A, one of the cells B C D E F will have a 1 in it Row 8 - title Row 9, text in cell A, one of the cells B C D E F will have a 1 in it and so on.. Layout is always the same. I want to summarize the 1s in a master sheet so I know how many of each reply there is. I only want to consolidate the cells where I have numbers, I do not want to bother about the text cells. Can someone help me with this? Thanks! |
Thread Tools | |
Display Modes | |
|
|