Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
One sheet, I have a list of numbers.
I want to search 5 other tabs/sheets within the same workbook to see if that number appears in the other tabs.
Ideally I'd like it to tell me which tab but I can deal with it just coming back to say yes or no.
Issue is that the numbers can be found anywhere in the sheets and not just in column A. So it has to search the whole sheet.
I want to search 5 other tabs/sheets within the same workbook to see if that number appears in the other tabs.
Ideally I'd like it to tell me which tab but I can deal with it just coming back to say yes or no.
Issue is that the numbers can be found anywhere in the sheets and not just in column A. So it has to search the whole sheet.