Hi,
This paragraph is basically background, and likely irrelevant, so skip to next paragraph for the problem description if you like.
Ok, so you have time to read this too, Thanks. So, having spent ours on this site reading posts and looking at solutions, I know there is some incredible Excel, VBA, and programming knowledge being passed around that has helped countless individuals. Unfortunately, I am not yet among them as it has become apparent to me that I am a long way from understanding a lot of this information and applying it to my own projects. I've downloaded examples and tried to reverse engineer the code to work with my worksheets, but I've not yet been successful, and as much as I'd like to solve this solo, I am out of time and humbly request help. I am sure there is a simple solution, and I apologize in advance that I didn't find it in my previous searches. It is likely I didn't know the correct terminology to search for what I am attempting, so if you could point me in that direction that too would be appreciated.
I am trying to create a workbook where the first worksheet displays various "Year to Date" totals as well as the current week's data entered into another worksheet within the same workbook. I plan on having 53 separate worksheets that represent the 52 weeks of the year and the 1 summary / totals worksheet. This may not be the best method so I am open to suggestions and changes. I think I solved how to increment the YTD totals by summing the same cells in each of the worksheets. I'm sure there is an easier way to do this, but this is the best I could come up with. I did notice that it was a solution in several forum posts so maybe it isn't that bad, just seems a little brute forced. My main sticking point is I am having a problem figuring out the best (any actually) method to move the data entered for the week to the summary page. I've attached a multi-sheet workbook which should make it easier to understand what I am attempting.
Thanks for the help.
Visitor Tracking.xls
Bookmarks