I'm using Excel 2002 to track budgets, actual costs and burn rates on a
project which has 20 sub-projects under the main project office. The first
sheet is linked to over 20 sub-project sheets, and is a summary of totals by
month and year for each sub-project, and then has project grand totals at the
bottom. This is a multimillion dollar project which will take 3+ years to
complete. The sub-projects have varying start and end dates.

As with any project, the schedule keeps shifting, especially as we get
closer to project launch. Or, sometimes the accounting dept. requests
scenarios of costs, for hypothetical schedule shifts, as a financial
forecasting tool.

You're probably all wanting to tell me this process begs to be managed by MS
Project. And you're right, it probably should be, as the project schedule is
already in MS Project but the budget is tracked separately in Excel and
because of time and resource constraints, will not soon be changed.

Here's the question. Can I use a formula or is there a quick way to shift
line items of cost by say 3 months, and across years? Some sub-project
sheets have 20 line items that need to be shifted.

Thanks for any suggestions you have.