Auto-Sum Cells over multiple worksheets - Real document is attached

**marshallstrong** · 08-08-2013, 04:14 PM

Hello everyone!
Sorry for posting in here but this forum is confusing and asking me to introduce myself first- I did that and it still wont let me post!

I HAVE ATTACHED THIS DOCUMENT, PLEASE FEEL FREE TO CHECK IT OUT OR DO WHAT IM ASKING!

But ill cut to the chase!
I have a workbook that I do for work and it tracks answer to how people found out about my health club and what they would like from it. Because we have monthly promotions I have to separate each months answers from the month before rather then letting the answers accumulate infinitely. How ever I was hoping to make a worksheet that would auto-sum the numbers from other worksheets onto one.
Here is where I am at right now.
-Name of workbook: Guest Checklist
-Names of worksheets: June2013, July2013, August2013, Accumulative.
-All of these worksheets have the exact same template, so for example cell "C5" on June2013 sources its answer from the same info as cell "C5" in July2013.

-What I was hoping to do was make the "accumulative" worksheet automatically sum up the totals for cell "C5" in worksheets June2013, July2013, August2013. So when I add to Augusts reports the accumulative worksheet will be always tracking everything for me.

What will this achieve? It'll stop me from having to use a calculator and add up all the numbers myself every Friday for my weekly reports. Itll save me a lot of time and be very helpful!

Thanks a lot everyone!

Marshall
Business Dev. NSD Sports and Fitness Club and Maverick Sports Management

**Jul Stev** · 08-09-2013, 12:32 AM

Hi Marshallstrong,

Since all the data sheets have the same format you can just use sum formula, try see attached file...

Guest Checklist update.xlsx

**marshallstrong** · 08-09-2013, 11:15 AM

Thank you so much Jul! That was seriously some of the best help I could have expected. That make sense how you added them all up now, I tried to do that way using videos I found online but I think I did it wrong.
Again though, thank you so much! My Friday reports are about 20 minutes faster now thanks to you

**Jul Stev** · 08-12-2013, 12:06 AM

No problem, glad i can help and thanks for the feedback

**lanibelles** · 12-03-2014, 12:59 PM

I have a similar problem. I have multiple worksheets and want to auto increment an alpha-numberic entry in the same cell across all the worksheets. So it would be S215-200 in the first worksheet and then the rest would be S215-201, S215-202. I normally do it one at a time but I often have over 100 worksheets. Can anyone tell me how to do this? I don't know how to do code. Is there a formula I should place in the first sheet or one I can place in grouped worksheets? Also, I don't want the cell numbering to change each time I open the file.

Auto-Sum Cells over multiple worksheets - Real document is attached

LinkBack

Thread Tools

Rate This Thread

Display

Auto-Sum Cells over multiple worksheets - Real document is attached

Re: Auto-Sum Cells over multiple worksheets - Real document is attached

Re: Auto-Sum Cells over multiple worksheets - Real document is attached

Re: Auto-Sum Cells over multiple worksheets - Real document is attached

Re: Auto-Sum Cells over multiple worksheets - Real document is attached

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula needed for auto fill across multiple worksheets-see attached spreadsheet

auto populate within multiple worksheets

Mail Merge Query - Multiple Excel Worksheets into Single Word Document?

Auto-Filter on multiple worksheets automatically via VBA

Auto increment over multiple worksheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions