S
ShaneS
Hello.
Is it possible to hyperlink between worksheets in a workbook to a location
based on a lookup criteria? I have a list of customers (and their details) on
one worksheet, and a list of sales on another worksheet which includes the
customer number. I want to click on the cell next to the customer number on
the sales worksheet, and go to the corresponding customer details on the
other sheet. Hope this makes sense! I have tried Vlookup to show details
permanently next to the sale but with thousands of sales and hundreds of
customers, this slows down the computer dramatically.
Thanks in advance!
Is it possible to hyperlink between worksheets in a workbook to a location
based on a lookup criteria? I have a list of customers (and their details) on
one worksheet, and a list of sales on another worksheet which includes the
customer number. I want to click on the cell next to the customer number on
the sales worksheet, and go to the corresponding customer details on the
other sheet. Hope this makes sense! I have tried Vlookup to show details
permanently next to the sale but with thousands of sales and hundreds of
customers, this slows down the computer dramatically.
Thanks in advance!