If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking cells in Excel 2007
I wish to link a cell which updates automatically in one worksheet to show
the same (current value in another worksheet within the same file - I tried hyperlink but got ~data? Help please |
#2
|
|||
|
|||
Linking cells in Excel 2007
Use the formula:
='Sheet Name'!A1 This will "link" to the cell A1 on the worksheet named "Sheet Name". Substitute your own sheet name and cell reference. Note the single quotes around the sheet name in the formula, which are only necessary if you have spaces or special characters in your sheet name. HTH Elkar "JJH281" wrote: I wish to link a cell which updates automatically in one worksheet to show the same (current value in another worksheet within the same file - I tried hyperlink but got ~data? Help please |
#3
|
|||
|
|||
Linking cells in Excel 2007
Many thanks for the info! It works!
"Elkar" wrote: Use the formula: ='Sheet Name'!A1 This will "link" to the cell A1 on the worksheet named "Sheet Name". Substitute your own sheet name and cell reference. Note the single quotes around the sheet name in the formula, which are only necessary if you have spaces or special characters in your sheet name. HTH Elkar "JJH281" wrote: I wish to link a cell which updates automatically in one worksheet to show the same (current value in another worksheet within the same file - I tried hyperlink but got ~data? Help please |
#4
|
|||
|
|||
Linking cells in Excel 2007
I have done this but the content in the cells within the same column keep
changing!! Help "Elkar" wrote: Use the formula: ='Sheet Name'!A1 This will "link" to the cell A1 on the worksheet named "Sheet Name". Substitute your own sheet name and cell reference. Note the single quotes around the sheet name in the formula, which are only necessary if you have spaces or special characters in your sheet name. HTH Elkar "JJH281" wrote: I wish to link a cell which updates automatically in one worksheet to show the same (current value in another worksheet within the same file - I tried hyperlink but got ~data? Help please |
#5
|
|||
|
|||
Linking cells in Excel 2007
See your other post for one suggestion.
Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 11:52:06 -0800, 5T4fr33d0m wrote: I have done this but the content in the cells within the same column keep changing!! Help "Elkar" wrote: Use the formula: ='Sheet Name'!A1 This will "link" to the cell A1 on the worksheet named "Sheet Name". Substitute your own sheet name and cell reference. Note the single quotes around the sheet name in the formula, which are only necessary if you have spaces or special characters in your sheet name. HTH Elkar "JJH281" wrote: I wish to link a cell which updates automatically in one worksheet to show the same (current value in another worksheet within the same file - I tried hyperlink but got ~data? Help please |
Thread Tools | |
Display Modes | |
|
|