Macro for linking two workbooks, comparing one document ID with

Solved/Closed
Hyundai123 Posts 2 Registration date Tuesday November 12, 2013 Status Member Last seen November 22, 2013 - Nov 12, 2013 at 02:17 AM
Hyundai123 Posts 2 Registration date Tuesday November 12, 2013 Status Member Last seen November 22, 2013 - Nov 22, 2013 at 07:00 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2013 at 12:05 PM
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

0
Hyundai123 Posts 2 Registration date Tuesday November 12, 2013 Status Member Last seen November 22, 2013
Nov 22, 2013 at 07:00 AM
Thank you TrowaD i used VLook up its working
0