Is it possible to copy a workbook with several worksheets & formulas to
another workbook without re-entering each formula to reflect a new year? I
created a budget workbook thats linked to another workbook that needs to be
updated every year. I'm able to copy the workbook but I have to put the new
year in each field manually. Are there any shortcuts or commands I can use
to make it less time comsuming? I can post an example of the formulas I use.
Any comments or suggestions will be greatly appreciated. thanks