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. |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com