EditLinksChange Links generally gets the job done.


Gord Dibben MS Excel MVP

On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R
wrote:

I have built a set of spreadsheets that track our plant operation.
It consists of one sheet we call the input sheet that we put our daily
readings in ( power, water,motor hour meter, etc.) and twelve sheets
(January - December) that have the formulas to draw the information to the
appropriate equipment.
My plans were to at the years end to save as to the next years date, wipe
out my input page and start over. Here is my delima. The save as sheet still
tries to draw from the previous years input page. Any ideas ?
Thanks