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.
Bookmarks