| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel spreadsheets
how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel spreadsheets
Hi,
you can have formulas in the 2nd spreadsheet. enter in sheet 2 cell a1 this and them copy it =sheet1!a1 "AngelEyes" wrote: how do i copy data from one sheet to another so that if the info changes on the first sheet it will automatically change on the second? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel spreadsheets
E.g. =Sheet1!A1
entered in Sheet2 A1 shall give the value of A1 in Sheet1 in A1 in Sheet2. -- Regards! Stefi €˛AngelEyes€¯ ezt Ć*rta: how do i copy data from one sheet to another so that if the info changes on the first sheet it will automatically change on the second? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheets | Excel Discussion (Misc queries) | |||
| Excel spreadsheets over WAN | Excel Discussion (Misc queries) | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| MS Excel Spreadsheets | Excel Worksheet Functions | |||
| Is this at all possible with Excel spreadsheets? | Excel Discussion (Misc queries) | |||
Linear Mode
