Forum Discussion

Copper Contributor

Jul 17, 2023

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...

excel

tanayprasad

Brass Contributor

Jul 17, 2023

KennyK360

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.

SergeiBaklan
Diamond Contributor
Jul 17, 2023
tanayprasad

Afraid that doesn't work, question was about simultaneous search.
- KennyK360
  Copper Contributor
  Jul 17, 2023
  Good catch Sergei...I have used "Within Workbook" but need simultaneous search for multiple numbers...any suggestions?
  - peiyezhu
    Bronze Contributor
    Jul 17, 2023
    
    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/consolidateWithNewF