colh99
08-19-2010, 01:54 AM
Hello everyone
I have a workbook with 2 sheets "input" and "links". The "links" sheet is a table of material codes, descriptions, suppliers, and a hyperlink to specification sheets for each material/supplier.
The user will enter a material code in A1 of the "input" sheet, vlookups will fill Cells B2:E21 with details of all the entries that match the code, i.e column B (code), Column C (material description) ,Column D (supplier), and column E (the row number of the links sheet that contains the hyperlink).
I would like a code so the once the user has entered a material code which, for example, returns 4 entries and selects the entire row containing the entry of interest and the marco will active the correct hyperlink in column G row ??? of the "links" sheet.
Being new to vba I cant record the macro because of the variable. I have looked on this and other sites for a clue of how to do it and I am either looking in the wrong places or not understanding what I see because what ever I have tried doesn't work.
Thanks in advance
I have a workbook with 2 sheets "input" and "links". The "links" sheet is a table of material codes, descriptions, suppliers, and a hyperlink to specification sheets for each material/supplier.
The user will enter a material code in A1 of the "input" sheet, vlookups will fill Cells B2:E21 with details of all the entries that match the code, i.e column B (code), Column C (material description) ,Column D (supplier), and column E (the row number of the links sheet that contains the hyperlink).
I would like a code so the once the user has entered a material code which, for example, returns 4 entries and selects the entire row containing the entry of interest and the marco will active the correct hyperlink in column G row ??? of the "links" sheet.
Being new to vba I cant record the macro because of the variable. I have looked on this and other sites for a clue of how to do it and I am either looking in the wrong places or not understanding what I see because what ever I have tried doesn't work.
Thanks in advance