Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking sheets in the same workbook
I am doing an expenses summary on one sheet and the detail in another whats
the best way to link them eg Sheet 1 grand total for expenses by month sheet 2 Details of individual expenses by month and totalled at bottom of column, this total I want to display in sheet 1 as the grand total. Normally I would use `sum total` on sheet 1 linked to the total on sheet 2, but I suspect this is not a good way to do this although it does work for me. Is there a better way to o this? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking sheets in the same workbook
On sheet 2 copy the total. On sheet 1, paste special, LINK. When the total
changes on 2 it will also on 1. "S S" wrote in message . uk... I am doing an expenses summary on one sheet and the detail in another whats the best way to link them eg Sheet 1 grand total for expenses by month sheet 2 Details of individual expenses by month and totalled at bottom of column, this total I want to display in sheet 1 as the grand total. Normally I would use `sum total` on sheet 1 linked to the total on sheet 2, but I suspect this is not a good way to do this although it does work for me. Is there a better way to o this? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 3 closed worksheets to master workbook template | Excel Worksheet Functions | |||
Linking formulas in new sheets based on a template? | Excel Worksheet Functions | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |