I have a template which will calculate various costs based on data I have entered in the "data" sheet. This contains rates and Inflation figures, so varies every year.

Is there a way I can make this the mastersheet so that when it comes to updating the "Data" sheet I only need to alter the template and not every workbook generated from it?

This could end up > 100, so if there is a way to do this I would be very interested in the solution.

George J

[ This Message was edited by: George J on 2002-02-21 09:37 ]