That worked. Thank you!
But how do I make it so that clicking on a specific cell ("cell1, worksheet1") takes me to a different worksheet (worksheet2) of the same document, where the data in a table gets instantly filtered by the value I have in the Cell1?
Is it possible?
Thank you in advance!
Quote:
Originally Posted by JP[_4_]
Go to InsertHyperlink, click "Place In This Document", choose where
you want to jump and click OK. A link is created; when you click on
it, the selection is changed to wherever you specified.
HTH,
JP
On Jan 25, 10:30*am, steve12345
wrote:
Hello
Thanks for looking at this:
I want to list a number of names on sheet one of a workbook and I want
to be able to click on a name and it take me to another worksheet, in
the same workbook which is linked to that name.
Can I do it?
All help is much appreciated
Thanks
Steve
--
steve12345
|