Pulling data from multiple workbooks

  • Thread starter Thread starter Mikefoa
  • Start date Start date
M

Mikefoa

I have at any one time a set of approx 200 workbooks that contain data in the
same format.

I would like to quickly identify the worksheets that contain a date in
either / or both of two cells. Same cells in each workbook.

Does anyone know if this is possible and is so how you do it? Looking to
have either the workbook highlighted or a frontend spreadsheet that tells me
which workbook to look at. This could be either by providing the workbook
name or information contained within a third cell of the original workbooks.

Pulling my hair out, so all help appreciated.
 
Hi Bob,

All workbooks are single sheet with no assigned name other than than the
usual sheet 1.

Mike
 
Back
Top