Macro for linking two workbooks, comparing one document ID with [Solved/Closed]

Report
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
November 22, 2013
-
Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
November 22, 2013
-
Hello,

I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in another workbook, eg. i have a document ID's in workbook "Book1" which has 1-11020, 1-11021... like wise i have 600 rows in column B "Book1" and have status of these documents in workbook "Book2" where the status of 1-11020....like wise i have 600 rows, starts from column B to column F.

Example:
Column B--Column C-------Column D-------------Column E---Column F
1-11020---Title----------Document Approved-----Date--------Name
1-11021---Title----------Document Rejected------Date--------Name
1-11022---Title----------Document Approved-----Date--------Name
1-11023---Title----------Document Approved-----Date--------Name

I want the output in Book 1 when i run the macro like below example in "Book 1"

Column B
1-11020
1-11020---Title--Document Approved--Date--Name "Datas from Book2"

Basically when i run the macro i want the status of the Document ID's searching in "Book2"

Kindly help me with the macro. Thank you in advance.

1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Hyundai123,

Seems to me like you could use VLOOKUP.

Open both books and apply formula like you would with different sheets.

Best regards,
Trowa

Posts
2
Registration date
Tuesday November 12, 2013
Status
Member
Last seen
November 22, 2013

Thank you TrowaD i used VLook up its working