Share via

"find-specific-data-within-multiple-excel-files"

Anonymous
2018-08-31T19:16:40+00:00

Hi

"find-specific-data-within-multiple-excel-files"

We have several hundred Excel files within a single folder on our network. We are looking for a way to search through each of those files to see if a single cell contains a particular value.

Any ideas?

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-08-31T21:47:44+00:00

    Have a look at the method found at Allan Wyatt's site.

    https://excel.tips.net/T005598_Searching_Through_Many_Workbooks.html

    Gord

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-09-01T17:18:59+00:00

    Suggest you visit Ron de Bruin's site and browse through the Merge Workbooks section.

    Note also Ron's Free RDBMerge Add-in.  Very handy tool.

    http://www.rondebruin.nl/win/section3.htm

    Gord

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2018-09-01T08:13:13+00:00

    Have a look at the method found at Allan Wyatt's site.

    https://excel.tips.net/T005598_Searching_Through_Many_Workbooks.html

    Gord

    Dear Gord,

    thanks for your interesting

    it is very close to what i need, however i would like to call up the value from specific cell from one excel ( which is exist within many excel file in specific folder)  to master excel file.

    in more details;

    i have several excel files , each one contains the daily data of our plant (many data), i build up the main excel file to do calculation based on these raw data,

    lets see i would like to call up the value of cell no. " D4 " from the daily data file (i shall define the required date).

    this mean after define the required date the specific value will be called up from the excel file of that selected date.

    appreciate your cooperation 

    thanks and best regards,

    Ahmed Hussien

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2018-09-02T12:21:58+00:00

    Suggest you visit Ron de Bruin's site and browse through the Merge Workbooks section.

    Note also Ron's Free RDBMerge Add-in.  Very handy tool.

    http://www.rondebruin.nl/win/section3.htm

    Gord

    Thanks

    0 comments