| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Linking workbooks | Excel Worksheet Functions | |||
| An error msg in Excel 2007 regarding Linking but no linking in fil | Excel Discussion (Misc queries) | |||
| Linking Excel 2007 to Powerpoint 2007 | Links and Linking in Excel | |||
| How do I turn off linking in Excel 2007? | Excel Discussion (Misc queries) | |||
| Linking Form to worksheets excel 2007 | Excel Discussion (Misc queries) | |||
Hybrid Mode
