xl2003
I have approx 5000 worksheets in about 500 workbooks.
What I want to do is to define a search criteria and then have it look
through all the workbooks and then copy the relevant worksheets to a new
workbook.
Is this possible? Will the workbooks have to open or can I look through
closed ones?
Or will I have to build a database? I had thought of copying every worksheet
to Access, doing the searches and then copying the results back to excel but
this seems rather longwinded.
Any help would be greatly appreciated.
Ta,
Martin