Thread: How do I set up a cell so that clicking the cell will switch worksheets?

I have a database with a set of summary records that refer to multi-part detailed records.
The summary records are on one worksheet and the detailed records are each on their own separate worksheet.
The summary record contains a field with the name (number) of the detailed record.
I want to be able to click on the cell containing the detail record name and switch the display to the worksheet for that record.
Is there some simple worksheet function to do this or do I need to write a macro or something?

Many thanks,
Hank

You need a macro, an event procedure probably, but what determines the sheet?

Thanks RoyUK. I've learned something useful today. The hyperlink works perfectly.
Hank