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
Bookmarks