I have to do my department budget in Excel. I am using formulas to get the totals for the weeks and putting that information in a separate sheet. For example:
April 8
60840-75 5000.00
60840-55 7000.00
April 15
60840-75 10000.00
60840-55 10000.00
(this is a running total that keeps calculating each month)
These sheets are totals and I am wondering if there is anyway to lock out April 8 so that it will not continue to calculate the changes. I want to know as of April 8 how much I spent, April 15 etc. Can this be done?
Thanks for your help!
April 8
60840-75 5000.00
60840-55 7000.00
April 15
60840-75 10000.00
60840-55 10000.00
(this is a running total that keeps calculating each month)
These sheets are totals and I am wondering if there is anyway to lock out April 8 so that it will not continue to calculate the changes. I want to know as of April 8 how much I spent, April 15 etc. Can this be done?
Thanks for your help!