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. |
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 |
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 |
All times are GMT +1. The time now is 07:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com