Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me toanother worksheet
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
Sounds like you are creating an Index Sheet.
You can do it by making each name a hyperlink to the appropriate sheet. My question is............how do you propose to get back to that original sheet so's you can pick another name from the list? If you right-click on the navigation arrows at bottom left you will get a list of 15 sheets and "more sheets". Selecting one of those will jump you to that sheet. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 15:30:23 +0000, 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
Gord Dibben,
Wouldn't you place a hyperlink on each sheet, back to the Index Sheet? -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule <<Previous Text Snipped to Save Bandwidth When Appropriate "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Sounds like you are creating an Index Sheet. You can do it by making each name a hyperlink to the appropriate sheet. My question is............how do you propose to get back to that original sheet so's you can pick another name from the list? If you right-click on the navigation arrows at bottom left you will get a list of 15 sheets and "more sheets". Selecting one of those will jump you to that sheet. Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 15:30:23 +0000, 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
Yes, you could do that but to my way of thinking why go those extra steps to
make a hyperlink on each sheet to go back to Index sheet to pick another sheet. You can use the right-click on the navigation arrows or build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord On Sat, 26 Jan 2008 00:37:23 -0500, "Rich/rerat" wrote: Gord Dibben, Wouldn't you place a hyperlink on each sheet, back to the Index Sheet? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
Gord,
I did not see those references on how to build a navigation toolbar, in your previous posting. And it would be something like I would do since I'm a novice with Excel. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule <<Previous Text Snipped to Save Bandwidth When Appropriate "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Yes, you could do that but to my way of thinking why go those extra steps to make a hyperlink on each sheet to go back to Index sheet to pick another sheet. You can use the right-click on the navigation arrows or build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord On Sat, 26 Jan 2008 00:37:23 -0500, "Rich/rerat" wrote: Gord Dibben, Wouldn't you place a hyperlink on each sheet, back to the Index Sheet? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I click on a cell on one worksheet and make it take me to another worksheet
They link was not posted in my first reply, but was certainly posted in my
second reply. See below. Gord On Sat, 26 Jan 2008 15:11:50 -0500, "Rich/rerat" wrote: I did not see those references on how to build a navigation toolbar, in your previous posting. And it would be something like I would do since I'm a novice with Excel. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule <<Previous Text Snipped to Save Bandwidth When Appropriate "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Yes, you could do that but to my way of thinking why go those extra steps to make a hyperlink on each sheet to go back to Index sheet to pick another sheet. You can use the right-click on the navigation arrows or build a Navigation Toolbar as per Dave's code on Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw |
#8
|
|||
|
|||
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a Hyperlink to a cell within another worksheet rela | Excel Discussion (Misc queries) | |||
make a cell equal a worksheet name | Excel Discussion (Misc queries) | |||
how do i name a excel worksheet and make it appear in cell a1 | Excel Worksheet Functions | |||
How do you make an excel worksheet cell a perfect square | Excel Discussion (Misc queries) | |||
can I make worksheet name equal a cell | Excel Worksheet Functions |