tracking data that links to second sheet and changes cells each day automatically

[sakr3d]

What I am trying to do is make a tracking sheet that has a couple of different "Buttons" that increase/decrease values (which I have already set up with the spin buttons) and then takes the information and places it in another sheet and stores it automatically and then the next day it starts the counter at zero again and at the end of the day saves it in a different cell on the second sheet. (IE sheet 1 A1 will display the increases from the button pushes. Sheet 2 D5 will display and save day one's button presses. Sheet 2 E5 will display day 2 (etc...). I am trying to make this as user friendly and hands off as possible. The people I'm wanting to be able to the tracking already have a lot on their plate and this tracking would help everyone out...so I'm just trying to keep it "mindless" if you know what I mean. Thanks for any and all help.

[rscsmith]

You could do this with a Workbook_BeforeSave macro, to write the value before the spreadsheet is saved. Worksheet_Change could also be used, but I suspect it is unnecessary to write it each time if you only need to record the value at the end of the day.

I don't understand the layout of your Sheet2. Not knowing makes it difficult to write the code for you. Is this going to go for a whole year? Week by week (reset on Monday), etc?

In short, we need to derive a pattern for where to store the value in Sheet1!A1 on Sheet 2.

With this, it is probably a 5 minute job to write the code.

Cheers, Rob.