Setting up macro betwen two sheets

[Moin]

In sheet 1 I’ve many columns. Out of that I’ve a column with market info in
column A and unique product ID in column B. Like that I’ve 100s of rows…
I also have another sheet where I’ve many columns. Out of which I have same
unique product IDs (total number could vary by more or less) in say column C
with a different column with associated PO# and SO# respectively in column D
and E.


I like a macro to pick the unique product ID on sheet 1 and go to sheet 2
and scan thru the column C to find the same unique ID and take the
corresponding PO (from col D) and SO # (from col E) and bring them back to
sheet 1 and put it right by in a vacant cell (say column C next to the
original unique ID )

Is it possible?

Kindly let me know the way if it is.

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.