So i have been asked to consolidate 3 sheets into 1, the file was setup with a sheet for each status, but that is becoming unmanageable. So it was discussed to make one of the sheets the master and just have a "status" column where they can flag each row appropriately.
Because each tab has between 15 and 31 or so columns in each tab, is there a way to do some form of conditional formatting or some formula to identify which columns are not in the next..
Sheet1 = 16 columns
Sheet2 = 15 columns
Sheet3 = 31 columns
The master needs to contain ALL columns found within each of the 3 sheets. So based on the numbers above, the master should NOT have less than 31.
I dont have a sheet right now to upload, but just need guidance / push in the right direction on how i can compare JUST the headers on each sheet to find what is missing from each sheet.
Bookmarks