Forum Discussion
How to create a search formula that will search an entire work book and summarise quantities
Since you have not given any precise information about your Excel version, operating system, storage medium, etc., it is difficult to understand what the digital environment is and which solutions are best suited or which are possible.
Nevertheless, I am sending you some solutions that might help you :).
Without VBA
Search should be performed across entire worksheet.
You can search a value or text not only in a specific worksheet but in the whole workbook,
please do as follows.
1) Activate the relevant workbook.
2) Start the search dialog by pressing the key combination Shift + F5 or Ctrl + F.
3) Click the Options button here. Additional search parameters are added to the dialog box.
4) Now select Workbook from the Search list box. Then click the Find All button.
With VBA
Added example file.
It's an old file that I got from the internet, unfortunately I don't remember where exactly. Believe it meets your specifications, or it's along those lines.
You could also try Power Query in Excel
…many roads lead to Rome and even more to an Excel solution :).
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.