Dear all,
I have 19 identical worksheets with information from different countries.
I would like to know all of these countries are doing as a whole. Using a
new worksheet that has an identical format to the other worksheets I would
like to calculate the sum of all the different countries from the other
sheets. Hope this is clear... Now do i have to like the cells of every
sheet individually or can I highlight all the sheets and as they are all
identical pick the cell which i would like the sum of. I have alread tried
the latter with no success and was wondering whether there is a method which
i did not know about or whether I do indeed need to go through each template