| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make spreadsheet content link to another sheet and have.
the content automatically update?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet and have.
See help on "linking"
Basics.............on sheet2 enter =sheet1!A1 Copy across and down. OR.......select a range on sheet1 and copy. Switch to sheet2, select a cell and EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking wrote: the content automatically update? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet andhave.
Use this large white space to explain your problem more fully.
You would generally use a formula like: =IF(Sheet1!A1="","",Sheet1!A1) to bring the contents from A1 of Sheet1 to another cell, but there are other ways which might be more suitable, depending on your exact requirements. For example, if the cell with the formula is to be dependent on another cell, then you might use one of the LOOKUP functions, or an INDEX/MATCH combination. Please describe what you want to achieve in more detail. Hope this helps. Pete On Aug 28, 3:31*pm, Hyperlinking Spreadsheets <Hyperlinking wrote: the content automatically update? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet and have.
"Hyperlinking Spreadsheets" wrote: the content automatically update? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet and h
"Gord Dibben" wrote: See help on "linking" Basics.............on sheet2 enter =sheet1!A1 Copy across and down. OR.......select a range on sheet1 and copy. Switch to sheet2, select a cell and EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking wrote: the content automatically update? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet and h
"Pete_UK" wrote: Use this large white space to explain your problem more fully. You would generally use a formula like: =IF(Sheet1!A1="","",Sheet1!A1) to bring the contents from A1 of Sheet1 to another cell, but there are other ways which might be more suitable, depending on your exact requirements. For example, if the cell with the formula is to be dependent on another cell, then you might use one of the LOOKUP functions, or an INDEX/MATCH combination. Please describe what you want to achieve in more detail. Hope this helps. Pete On Aug 28, 3:31 pm, Hyperlinking Spreadsheets <Hyperlinking wrote: the content automatically update? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make spreadsheet content link to another sheet and h
"Gord Dibben" wrote: See help on "linking" Basics.............on sheet2 enter =sheet1!A1 Copy across and down. OR.......select a range on sheet1 and copy. Switch to sheet2, select a cell and EditPaste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking wrote: the content automatically update? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| how do I link tab name to content of a cellt? | Excel Discussion (Misc queries) | |||
| How can i make link to different sheet | Links and Linking in Excel | |||
| how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions | |||
| Use Cell Content to Build Link | Excel Worksheet Functions | |||
Linear Mode
