A
Andy G
I am using the excel template for a monthly budget. I have copied the sheet
to make many sheets (12 for each month) in one workbook. I want to
reference the months previous "Actual Cost" to use on the current month's
"Projected Cost". I have to do that manually every time I copy to a new
month. Is there a way to tell Excel to reference the right month? So if I
copy the July sheet into and August sheet the Projected cells will reference
July's actual costs and not Junes actual costs.
One more thing...Can I set up excel so that if I make a field change in one
sheet it will make the change in all sheets in the workbook. Ie. Changing
the label in a cell in one sheet would change that same label in every
sheet.
Thanks for the help!
to make many sheets (12 for each month) in one workbook. I want to
reference the months previous "Actual Cost" to use on the current month's
"Projected Cost". I have to do that manually every time I copy to a new
month. Is there a way to tell Excel to reference the right month? So if I
copy the July sheet into and August sheet the Projected cells will reference
July's actual costs and not Junes actual costs.
One more thing...Can I set up excel so that if I make a field change in one
sheet it will make the change in all sheets in the workbook. Ie. Changing
the label in a cell in one sheet would change that same label in every
sheet.
Thanks for the help!