Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
progress billing / billed to date formula
each month, i copy and paste the worksheet at the end of my workbook (we will
call it B) that was used for last months invoice. the worksheet contains references to the sheet before it (call it A), so i have to rename those references in the new sheet (call it C). i know there is an easier way to do it...anyone know how? this is my invoice setup: Sheet C(links to B) Sheet B(link to A) Sheet A(etc) 1.contract B, 5 A, 5 etc, 5 2.billed previous B, 4 A, 4 etc, 4 3.current amount manual manual manual 4.billed to date 2+3 2+3 2+3 5.contract balance 1-4 1-4 1-4 thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |