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!

[Cheeky Charlie]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

[rowlandjp]

Not sure how to delete a post, but please see following post.

[rowlandjp]

NM, this is due to the server problem ya'll are having.

Apologies. Marked as solved.

Please refer to prior post for request.