looping through data

[sa02000]

I have two sheets of data. First sheet has a list of part numbers. Second sheet has part numbers in one column and projects in second column.

So for each part number in first sheet, I need to look up that part number in second sheet and store the corresponding projects (more than one)associated with that part number in a variable in macro. Once I have project numbers associated with given part numbers in a variable I will look up each of those projects in another sheet to get other information on the project and process it further.

Does anyone have any code that can loop through all the rows in first and second sheet and do something similar?

Thank you very much in advance.

Jay

[Carim]

Hi,

Have you tried the index() match() combination ?

HTH
Carim

[sa02000]

Carim, Thanks for the reply but I don't know how to use worksheet functions in macro... I am a beginner on this VBA stuff.. do you have any examples from your past work... I tried looking up Index in help and couldn't find anything good.

Jay

[Carim]

Hi,

Are you sure you need a macro just to lookup values...?

Carim