Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transfering a changing cell value progressively through a workbook
I am creating a payment application form in excel 2007 using windows 7. Each
worksheet represents one months invoice. Say I have a formula in "sheet 1/ cell Q7" that sums the total billed to date for a particular budget line item. This value will be transfered to a the next months payment application "sheet 2/ cell K7" this becomes the total amount of previous applications, then "sheet 2/ Q7 is =sum(K7,M7,O7) this value is transfered to "sheet 3/ K7, and so on and so on, until the completion of the job. How do I acomplish this. -- Thanks Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfering cell values progressively through worksheets | Excel Worksheet Functions | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Transfering Workbook | Excel Discussion (Misc queries) | |||
Transfering 100 named ranges to an another workbook | Excel Discussion (Misc queries) | |||
Formulas not working after transfering to new workbook | Excel Worksheet Functions |