LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ant
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 1 June 6th 05 06:37 PM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
What formula do I use to link worksheets together within one spre. Juarez1 Excel Worksheet Functions 2 October 28th 04 08:51 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"