Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Across Sheets
Have files with 52 tabs of sheets each.
21 columns across, each with a VLOOKUP to the bottom of the sheet. On each sheet, the VLOOKUP table looks kinda like this: 0 - Scenario 0 1 - Scenario 1 2 - Scenario 2 etc. HOWEVER, at some point over the course of time, you will have, on say, Tab 14, 0 - Scenario 0 1 - Scenario 1 2 - Scenario Springsteen and on, say, Tab 36, you could have 0 - Scenario 0 1 - Scenario 1 2 - Scenario Quesadilla Is there a quick and dirty way to compare all 52 sheets and see where there are changes in a particular cell? (2 - Scenario Xxx will always be in same cell position, regardless of sheet) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing Across Sheets
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Two Sheets | Excel Worksheet Functions | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Worksheet Functions | |||
Comparing two Excel sheets | Excel Discussion (Misc queries) | |||
comparing and compiling between sheets | Excel Discussion (Misc queries) |