Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto copy total from one workbook to another workbook
Have two workbooks in excel 2003 need to auto a numbers placed in workbook 1
to auto copy into workbook 2 workbook 1 C4:c31 total in c32 need to copy this to workbook2 c4 & auto update as number rises |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto copy total from one workbook to another workbook
Hi,
Open both workbooks. Choose Window, Arrange, OK Select cellC4 in book2 Type = and then click on book1 and then on the sheet with the values, then on cell C32. Press Enter. This creates a formula between two workbook and when workbook 2 changes and workbook 1 is opened it will update or prompt you to update. -- If this helps, please click the Yes button Cheers, Shane Devenshire "hugrl" wrote: Have two workbooks in excel 2003 need to auto a numbers placed in workbook 1 to auto copy into workbook 2 workbook 1 C4:c31 total in c32 need to copy this to workbook2 c4 & auto update as number rises |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto save a backup copy of a workbook | Excel Discussion (Misc queries) | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
auto update of copy of workbook | Excel Worksheet Functions |