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) |
Comparing Across Sheets
|
All times are GMT +1. The time now is 01:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com