Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I link single cells in a spreadsheet to another worksheet?
I use an excel spreadsheet to list job numbers for the trucking industry.
Each Job is defined by its number and all information is maintained by that number. I also set up a spreadsheet that holds all of the pricing for each individual job number. Is there a way that I can attach, via a link, the pricing worksheet to an individual cell in the list with each job number. I would like to be able to open one spreadsheet and still locate all of my info. |
#2
|
|||
|
|||
Can I link single cells in a spreadsheet to another worksheet?
Ctrl K or go to Insert Hyperlink Browse for the file you need it will insert the link into the sheet You can use that link to go to that particular sheet when you click on it :) -- ufo_pilot ------------------------------------------------------------------------ ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972 View this thread: http://www.excelforum.com/showthread...hreadid=477500 |
#3
|
|||
|
|||
Can I link single cells in a spreadsheet to another worksheet?
Actuall I just read that you wanted a single cell Well: you can use this formula: =IF(GP7<"",GP7,"") use function: IF logical test = CLICK on cell in other workbook TYPE: <"" Value if true= CLICK on cell in other workbook Value if false= TYPE: "" this will then automatically update whenever the cell changes -- ufo_pilot ------------------------------------------------------------------------ ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972 View this thread: http://www.excelforum.com/showthread...hreadid=477500 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link cells from one excel worksheet to another? | Excel Worksheet Functions | |||
Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |