Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching 5 or 6 excel files for specific data...
I need to be able to search 5 or 6 separate excel files that in turn hold
around 10,000 rows of customer data each and find precise records... For instance I need to find PAUL SMITH of LONDON with postcode E17 4AJ, how can I do this simply? Regards Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching 5 or 6 excel files for specific data...
I would load the data into Access or some other database. For perfomance and
ease this would be my favorite option... Then you can query out whtever your heart desires. Not to mentionit puts all of your data in one basket... To quote Andrew Carnegi... Put all your eggs in one basket and then watch that basket. Just my two cents... "Scott" wrote: I need to be able to search 5 or 6 separate excel files that in turn hold around 10,000 rows of customer data each and find precise records... For instance I need to find PAUL SMITH of LONDON with postcode E17 4AJ, how can I do this simply? Regards Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching 5 or 6 excel files for specific data...
One simple way is AutoFilter the columns.
There are lots of other ways to grab data but they are not as simple. "Scott" wrote in message ... I need to be able to search 5 or 6 separate excel files that in turn hold around 10,000 rows of customer data each and find precise records... For instance I need to find PAUL SMITH of LONDON with postcode E17 4AJ, how can I do this simply? Regards Scott |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching 5 or 6 excel files for specific data...
Unfortunately I do not have that option. The only option I have is to
search each of the files and as opposed to opening each one individually and searching I'm sure there must be a way I can automatically search each one from one location and produce the desired results. It doesn't matter if the code is slow and crude... I just need something to get my teeth into!!! Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for specific text - how to | Excel Worksheet Functions | |||
Searching for case specific data | Excel Discussion (Misc queries) | |||
Searching large excel files | Excel Discussion (Misc queries) | |||
Excel quits responding searching for files not in my documents | Excel Discussion (Misc queries) | |||
Searching for specific text | Excel Programming |