Time Stamping

[chrisdantonelli]

Is it possible that each time a number is entered onto sheet 1 I2, a copy of that information is carried over to Sheet 2 with a time stamp even though I2 is designed to erase after input. attached is a created scenario that I made up implying that 3 inputs were made each of user input 2 for a total of 6. Let me know if this is doable because this would capture the data best I believe. Thanks for looking! time-stamp-time-date-stampR1.xlsm

[walruseggman]

This belongs on Sheet1. Looks like you've already got a Worksheet_Change event on that sheet. If so, just copy the If statement in the code below and insert it at the end of your Worksheet_Change event.

Please Login or Register  to view this content.

Edit: First post as a Forum Expert. Wahoo!