SEARCH IN MULTIPLE WORKBOOKS?

dkr1 · May 13th, 2002, 10:47 AM

Today I will save workbook as "51302" in
folder "MAY02". I do this daily in monthly folders. If I need to find what report I posted a particular invoice # into I have to open each workbook for that month until I stumble into the correct one. Is there any way around this?
Thanks...

The invoice #s are in A, 7 thru 56 on every sheet. A search by month would be cool, three months back would be plenty...
Index file record?

[ This Message was edited by: dkr1 on 2002-05-13 10:28 ]

Tom Schreiner · May 13th, 2002, 10:59 AM

I would create an index file record.
For now, you could automate the lookup through multiple workbooks.
How far back would you need to search?
Where are your invoice numbers located?
In which cells, on which sheets?
I would create a seperate workbook to do your searching.
Please post some more details so we can help you out.
Thanks,
Tom

Corticus · May 13th, 2002, 11:11 AM

I would make one spreadsheet that contains each months data on a unique tab. You can pull values from the files onto the tabs,
then use Hlookup to search over the array of tabs,
it would probably be easier to consolidate this data to one workbook for a whole lot of other reasons, as well...

Corticus

klb · May 13th, 2002, 01:19 PM

Why not use Windows Explorer - Tools - Find - Files or Folders

Under the Advanced tab you can specify the text that you are searching for.

Nimrod · May 13th, 2002, 01:26 PM

Excel has an advanced find utility that will allow you to search by file content:

-Excel Toolbar
--file
---open
----tools
-----find

May 13th, 2002, 01:26 PM	#5
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Excel has an advanced find utility that will allow you to search by file content: -Excel Toolbar --file ---open ----tools -----find __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 10:47 AM	#1
dkr1 New Member Join Date: May 2002 Location: Kansas Posts: 5	Today I will save workbook as "51302" in folder "MAY02". I do this daily in monthly folders. If I need to find what report I posted a particular invoice # into I have to open each workbook for that month until I stumble into the correct one. Is there any way around this? Thanks... The invoice #s are in A, 7 thru 56 on every sheet. A search by month would be cool, three months back would be plenty... Index file record? [ This Message was edited by: dkr1 on 2002-05-13 10:28 ]

May 13th, 2002, 10:59 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I would create an index file record. For now, you could automate the lookup through multiple workbooks. How far back would you need to search? Where are your invoice numbers located? In which cells, on which sheets? I would create a seperate workbook to do your searching. Please post some more details so we can help you out. Thanks, Tom

May 13th, 2002, 11:11 AM	#3
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	I would make one spreadsheet that contains each months data on a unique tab. You can pull values from the files onto the tabs, then use Hlookup to search over the array of tabs, it would probably be easier to consolidate this data to one workbook for a whole lot of other reasons, as well... Corticus

May 13th, 2002, 01:19 PM	#4
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Why not use Windows Explorer - Tools - Find - Files or Folders Under the Advanced tab you can specify the text that you are searching for.