Hyperlinking back to cell with matching data

[mattmc419]

Hey Guys,

On the attached workbook, the "Vendor" dropdown list on the "Data Entry" sheet is dynamically populated by the "Company Name" column on the "Vendor Info" sheet.

When you hit the "Record Data" button, it transfers everything over to the "Records" sheet.

Is there a way to make the "Vendor" text that gets transferred over to the "Records" sheet hyperlink to the corresponding row for that company on the "Vendor Info" sheet through VBA?

[:) Sixthsense :)]

In S9 Celll of Vendor Info Sheet

=IFERROR(HYPERLINK("#Records!A"&MATCH(A9,Records!A:A,0),"Go"),"")

Drag it down..

[mattmc419]

Thanks,

I really want the hyperlink to be in the "Vendor" column on the Records sheet, and link to the appropriate Vendor on the Vendor Info sheet.

So far I've been able to implement a loop and get the hyperlink to be added. It links to the correct cell, but on the wrong sheet.

Is there a way to make it link to the other worksheet?

Here's what I have right now, and I'm attaching an updated file too;

Please Login or Register  to view this content.