I have a workbook called Tax Account numbers.xlsm and once called BR1 Tax Data.xlsm
I would like a macro to compare the sheet tabs and extract that on tax Account numbers.xlsm and not on BR1 Tax Data.xlsm and vice versa in Col A and list the workbook name in Col B
The macro can be on a seperate workbook on sheet Compare
Your assistance is most appreciated
I would like a macro to compare the sheet tabs and extract that on tax Account numbers.xlsm and not on BR1 Tax Data.xlsm and vice versa in Col A and list the workbook name in Col B
The macro can be on a seperate workbook on sheet Compare
Your assistance is most appreciated