Lookup from other workbooks and return adjacent data

[rowlandjp]

Good morning,

I'm currently stuck trying to figure out how to do a macro which takes data from a "transfer log" and finds the data in other open workbooks to return adjacent data.

The attached examples are for a part number and a part. So I'd like to run a macro from the transfer log to find the part number in the attached "report" and return the part in the cell next to it. Report will always be the prefix of the title, but it may vary. The same goes for the sheet name of the report. The column values, however, are consistant.


Thank you very much for any help you can give!

[rowlandjp]

Figured it out:

Please Login or Register  to view this content.