Results 1 to 2 of 2

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

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    front royal, va
    MS-Off Ver
    excel 2010
    Posts
    1

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

    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.
    Last edited by sakr3d; 12-21-2011 at 08:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1