| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In between the sheets?
Can I automatically transfer cell values from one sheet to another within the
same file? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In between the sheets?
Enter following formula with desired sheet name and cell reference
='My Sheet'!A1 HTH -- AP "Jim" a écrit dans le message de news: ... Can I automatically transfer cell values from one sheet to another within the same file? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In between the sheets?
Not 100% sure what you mean by automatically transferring, you can go into
your 2nd sheet and double click the cell type = and then go to the 1st sheet and click on the cell you want to update from. you should end up with something that looks like this in the 2nd sheet cell =Sheet1!A1 This cell will then display whatever is in A1 and will change as you change the value of A1 in sheet 1 "Jim" wrote: Can I automatically transfer cell values from one sheet to another within the same file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Macros-creating new sheets | Excel Worksheet Functions | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Hybrid Mode
