Forum Discussion
Searching multiple worksheets for different numbers simultaneously in Excel
Is it possible to search multiple worksheets for different numbers simultaneously in Excel? Using CTL-F isn't working for me. For example, can I search 10 different worksheets all at once for t...
Hi,
As suggested by Detlef_Lewin , After pressing Ctrl + F, you can Go to "Options" and change the scope to "Within Workbook".
That will run your search across the whole workbook which includes your 10 worksheets.
Best Regards.
Afraid that doesn't work, question was about simultaneous search.
- Good catch Sergei...I have used "Within Workbook" but need simultaneous search for multiple numbers...any suggestions?
Yes,you can use Ms Access and run sql like.
select * from yourtable where f=137 or f=142 or f=154
I use this:
https://b23.tv/jWpwmwK
http://e.anyoupin.cn/EData/?p=tools.consolidate.consolidateshts/consolidateWithNewFNope, sorry, no suggestions. Plus question is unclear. If the speak about Ctrl+F (let forget about simultaneous search for a while) it returns list of cell references which match.
If we start speaking about SQL, Access, etc (assume such tools work) - what exactly shall they return.
Other words
Input: list of values
Output: ???
