Hi, I have a workbook with 2 sheets with data from an external database.
Sheet 1 is "Products" and sheet 2 is "Issues". On the first sheet i have a clumn where i do a lookup for eacht product to see if there are one or more Issues listed on the "Issues" sheet. If any issue is found i want to make a Hyperlink in the next collumn on the "Products" sheet. For this i used the following formula
=IF(VLOOKUP(L4;Issues!A:G;4;1)=1;HYPERLINK(Issues!$A$1;"Issue");"").
For now this works!
The next think i would like to do is when i click the hyperlink i want to go to the "Issues" sheet and modify the autofilter parameters so i only the issues for the according product on the "Products" sheet.
If anyone can help please let me know
Thanks in advance, Boekkie
Bookmarks