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!