Results 1 to 1 of 1

Counter to add 1 to another file's cell based on third cell's date.

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    Fairbanks, AK
    MS-Off Ver
    Excel 2010
    Posts
    1

    Counter to add 1 to another file's cell based on third cell's date.

    I hope this is not as complicated as it sounds.

    I have a button in a blank spreadsheet (Excel 2010) that several people will click throughout the day. My intention is to have that click counted in the cell of another file, but be able to recognize the current date (in a column of sequential dates) and put that count in a related cell in an adjacent column.

    For instance, the button in File1 is clicked; that sends a +1 to File2. Today's date is in, say, cell B20 of File2 and the tally should go in cell D20. Tomorrow, everything shifts down by 1 row. Next month, the cell starts near the top, but 4 columns over. The distance between the date column and the count column remains consistant.

    Any insight would be great.

    -Quick Edit-

    I failed to mention that the data needs to be stored in a specific worksheet.
    Last edited by slowery82; 03-01-2013 at 08:14 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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