I am looking for a formula that will add the same cell from multiple pages in a spreadsheet.
Example of pages with different titles:
joe1, joe2, joe3, al1, al2, al3, jane1, jane2, jane3
I just want to add cell L23 from sheets named al1, al2, al3.
Any help would be appreciated.
Thanks,
Last edited by jklangenberg; 07-14-2011 at 06:21 PM. Reason: Solved
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Multiple page or multiple sheet?Originally Posted by jklangenberg
"Add cell" means to calculate SUM value from L23 in sheets amed al1, al2, al3, and Where is the result put in ?
Do I have to list them each out or is there a way to say all of the Al*.*!L23?
Multiple page
I have the cover sheet receiving the total
Without the use of VBA, you have to list them out.
What is VBA?
You can put the worksheets you want to total between two blank worksheets say called Start and End and then use a formula like this: =SUM(Start:End!L23)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Excellent Dom. Thanks.
Excellent Dom. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks