Search numerous spreadsheets for specific data.

[Guest]

I have 125 30-page job enrollments, each a separate Excel workbook. I can
place some of these people in regular. However, I need to "filter" or "query"
or "search" all the workbooks for such specifics as name, phone number,
veteran Yes/No.

I have some superficial experience in Excel, but I don't know how to do
this. Ideally the end result would be a printout of all the named enrollees
and their phone numbers who are veterans. using Excel 2000.

Can you help? Thanks. Chris

 

[Otto Moehrbach]

Chris
Do you have 125 workbooks? Are all the workbooks in the same folder?
What is "30-page job enrollments"? What do you mean by "I can place some of
these people in regular."? Is "veterans" the only criteria you want to
search for? Do you need to search in every sheet in each workbook or just
specific sheets? Is the layout the same in each sheet in every workbook?
By layout I mean "Column A contains this, Column B contains that, Column C
contains this other, the names start in row X, etc. Post back with answers
to these questions and I or someone else will be able to help. HTH Otto