Share via

How do I search Data across multiple excel workbooks files?

Anonymous
2016-05-14T15:04:48+00:00

I have hundreds of Excel files saved in a specific folder in my computer, but when someone asks me to find something and I don't know which workbook it is in, is there a way that I can lookup multiple workbook files in folder and search which file this specific data is in?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-14T16:58:19+00:00

    You could start by just using an Search via an Explorer window. How you do this depends on what version of Windows you are using. If you are using Windows 10, the search box to search within files is in the upper right corner of the Explorer window. Navigate to the folder you want to search in first.

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-05-15T08:41:16+00:00

    Hi,

    are you familiar with vba macros ?

    0 comments