Hello all,
I have a file with the following column headings:

1> Master list of Part Numbers (15000 entries)
2> My Part List (1400 entries)
3> Station Number (15000 entries)

For a basic explanation, a part number can be present at multiple station numbers.

What I need to do is find out all the (STATION NUMBERS) for (MY PART NUMBERS) from the (MASTER LIST OF PART NUMBERS)

Please help.

Ill be more specific:
There are two excel files:

File 1 has the following columns:
1> Master list of Part Numbers (15000 entries)
and the corresponding
2> Station Number (15000 entries)
for example:
Master list Station Number
1> Part a 1
2> Part b 2
3> Part c 3
4> Part b 5
5> Part b 8
6> Part d 6


File 2 has:
1> My Part List (1400 entries)
for example:
My Part list
1> Part b
2> Part c
3> Part d


Now, a part number in the (Master list of Part Numbers) can be present at multiple (Station Number).
What I need to do is get all the (Station Number) for the entries in (My Part List).
So according to the given example, I need to find out the station numbers for Parts b,c and d.
Part b will have station number as:2, 5 and 8
Part c will have station number as:3
Part d will have station number as:6

There are multiple ways to do this

1. Loop through the list and use Find function to check the availability of partnumbers in the master file

2. Use Excel ADO - that is use the master file as the database - Query for presence of record using ADO (http://vbadud.blogspot.com/2008/05/u...-database.html)

3. USe Excel ADO - consider both the Master and Data file as Databases, run a join query and get the result in new sheet

While you try these approach some wizards in this forum might come with new techniques too

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

There are multiple ways to do this

1. Loop through the list and use Find function to check the availability of partnumbers in the master file

2. Use Excel ADO - that is use the master file as the database - Query for presence of record using ADO (http://vbadud.blogspot.com/2008/05/u...-database.html)

3. USe Excel ADO - consider both the Master and Data file as Databases, run a join query and get the result in new sheet

While you try these approach some wizards in this forum might come with new techniques too

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)