Formula which adds together worksheets
 

Sounds easy - however I am looking for a formula which adds together the same
cell across identical worksheets that do not exist. Confused? Well - the
template I have set up allows the user to select a country and then run a
macro that creates a new worksheet for that country. These worksheets are
identical. Once they have selected all the necessary countries the "Total"
worksheet needs to have a formula which adds them all up. The problem is that
I can't have a normal formula in the Total sheet before the new countries
templates have been set up.

Any ideas?

Check out the *end* of this old post:

http://tinyurl.com/dhqza

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Ant" wrote in message
...
Sounds easy - however I am looking for a formula which adds together the
same
cell across identical worksheets that do not exist. Confused? Well - the
template I have set up allows the user to select a country and then run a
macro that creates a new worksheet for that country. These worksheets are
identical. Once they have selected all the necessary countries the "Total"
worksheet needs to have a formula which adds them all up. The problem is
that
I can't have a normal formula in the Total sheet before the new countries
templates have been set up.

Any ideas?