Hi All,
I am wondering if the following is possible. I have developed two models. One Model is per country and the other is per Region. The two models are named "Country Model" and "Region Model" respectively. To fill the model I copy the model in a new worksheet and fill it with the appropriate information. The new worksheet is named after the selected country or region. (The country is a lower level than the region which is basically a group of countries)
In a third worksheet I want to keep a sum of all created worksheets (so countries and regions together).
Is it possible to have the sum automatically adding a new created worksheet? nb the two models are identical in size and reference to a cell.
The outcome should look like this
The current sum in the Total Worksheet:
="Italy Model"!C1+"UK Model"!C1+"Africa Model"C1
Now i add a new worksheet named "USA Model"!
The SUM in the Total worksheet should now look like:
="Italy Model"!C1+"UK Model"!C1+"Africa Model"C1+"USA Model"!C1
I hope you have a solution. Thanks a lot for any help!!
Robbert
I am wondering if the following is possible. I have developed two models. One Model is per country and the other is per Region. The two models are named "Country Model" and "Region Model" respectively. To fill the model I copy the model in a new worksheet and fill it with the appropriate information. The new worksheet is named after the selected country or region. (The country is a lower level than the region which is basically a group of countries)
In a third worksheet I want to keep a sum of all created worksheets (so countries and regions together).
Is it possible to have the sum automatically adding a new created worksheet? nb the two models are identical in size and reference to a cell.
The outcome should look like this
The current sum in the Total Worksheet:
="Italy Model"!C1+"UK Model"!C1+"Africa Model"C1
Now i add a new worksheet named "USA Model"!
The SUM in the Total worksheet should now look like:
="Italy Model"!C1+"UK Model"!C1+"Africa Model"C1+"USA Model"!C1
I hope you have a solution. Thanks a lot for any help!!
Robbert