Linking cells in different spreadsheets
Thanks Steve, that is exactly what I wanted to do, your a star!!
"SteveH" wrote:
Easy!
Click on the cell where you want the linked data.
Key in the equal sign: =
Navigate to the cell you wish link
Press enter
If you are linking to a cell in another workbook the cell will look
something like this
='[Workbook Name.xls]Tab Name'!$E$16
Where $E$16 is the cell location
Note that the cell location is an absolute reference so if you want to
extend the selection by dragging the cell you must first remove the absolute
reference.
If you are linking to a cell in the same workbook the cell will look
something like this
=Tab Name!Cell E16
Note that the cell location is not an absolute reference
HTH
Steve
"Sheilad" wrote in message
...
I want to link a number of cells from different spreadsheets into one main
stock control spreadsheet and I've no idea how. Any suggestions?
ie Stock control = 200
Order Number 50
therefore stock control should decrease to 150.
Many thanks in advance
|