XcelNoobster
New Member
- Joined
- Jun 7, 2022
- Messages
- 40
How would search numerous sheets for a number and output the location where it's found on a new sheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to search numerous sheets for a specified text?
- Thread starter XcelNoobster
- Start date
PeteWright
Active Member
- Joined
- Dec 20, 2020
- Messages
- 425
- Office Version
- 365
- Platform
- Windows
- Mobile
You could simply press [Ctrl]+[F] to open the search box, type your number and then expand the dialog by clicking on [Options > >]:
Within: Workbook
Search: By Rows
Look in: Values
After the search is done a list appears at the bottom.
Within: Workbook
Search: By Rows
Look in: Values
After the search is done a list appears at the bottom.
Upvote
0
