| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
links
I want to link to a certain cell in a different worksheet.
How do I do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
=sum(SheetXX!A1:A10)
the sheet name preceeds the rest range reference. SmartyPants wrote: I want to link to a certain cell in a different worksheet. How do I do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
wrote: =sum(SheetXX!A1:A10) the sheet name preceeds the rest range reference. SmartyPants wrote: I want to link to a certain cell in a different worksheet. How do I do this? I'm sorry, I guess I was unclear before. I want the person veiwing the current worksheet to be able to view the other worksheet, at a certain cell. Either by opening the worksheet or opening a veiw of some sort. Any Help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
Are you referring to linking workbooks vs. worksheets?
SmartyPants wrote: wrote: =sum(SheetXX!A1:A10) the sheet name preceeds the rest range reference. SmartyPants wrote: I want to link to a certain cell in a different worksheet. How do I do this? I'm sorry, I guess I was unclear before. I want the person veiwing the current worksheet to be able to view the other worksheet, at a certain cell. Either by opening the worksheet or opening a veiw of some sort. Any Help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
wrote: Are you referring to linking workbooks vs. worksheets? Maybe what I need is a macro to open another workbook at a certain point. I want the person to be able to view another workbook at a certain point (tab,cell). |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
My post from yesterday in the public.excel.misc group has a way...
http://tinyurl.com/wytao -or- Go to the Insert menu and select "Hyperlink..." -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "SmartyPants" wrote in message wrote: I want the person to be able to view another workbook at a certain point (tab,cell). |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
links
Sheet name preceeds the range reference
eg. =sum(Sheet2!A1:A10) SmartyPants wrote: I want to link to a certain cell in a different worksheet. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| Relative Links becoming Absolute Links? | Excel Programming | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Hybrid Mode
