Vba code to add hyperlink to sheet of another workbook

Hello Everyone,
I have two database
( 1). name it as "Status Database")
( 2). name it as "Reference Database")
Status Database have some reference number in column C.
and same reference number are there in Reference Database in row 1.

what i want to achieve is
when ever an update command is called
macro should lookup the data in column c of status database and search the same in reference database and give its hyperlink to that particular cell.

sample file is attached

I will be very grateful if i get an help on this.
Thank u in advance.

The following macro assumes that the workbook "Reference Database.xlsm" is in the same location.

Please Login or Register  to view this content.

Artik

Hello Artik,
Thank you for the reply to my query.

Your code worked perfectly in this sample file.
but when i use this code in the main files, I get error.

Main file name is
1) KwenG Order Gantt Chart
2) Master Work Order 21-22

my files are on not server pc.

If there are other file names or their locations, you should adapt the variable assignments in the main procedure on your own:

Please Login or Register  to view this content.

Artik

Hey Artik,
Thank you for your time for solving the query
Your code worked and problem solved.

Thank u very much