Hi,
Every 2 months i have to prepare a financial forecast.
This forecast is to be presented in various ways.
This activity becomes tedious since the same info is to be presented i
a number of ways.
So i have linked the forecast sheet with another "Master Input Sheet".
This "master input sheet" enables me to present the forecast data in
variety of ways with ease.

The "Master Input Sheet" and "forecast sheet" are kept in the sam
file.

However,the forecast undergoes changes every 2 months.

I tried deleting the previous months forecast sheet and inserting th
new forecast sheet.
But the "Master Input sheet" throws up the #REF error.

Linking the "Master Input sheet" again is a tedious process.

Can I retain the links in the "Master Input Sheet" and keep on addin
new forecast sheets?

Thanks

--
Message posted from http://www.ExcelForum.com