Copy cell upon close

Hi all,

I have the below VBA code and I'm looking to amend it so that when the end user closes the workbook, it will copy a specific cell and paste it in the next blank spot in a column.

In this case, I want it to copy cell F4 and paste it in the next blank cell in column B. The VBA code will then add the date that number was entered.

Bonus points if you're able to make it so that it does NOT copy if the number has not changed!! That would result in a bunch of unnecessary data points (trying to track the date the number changes).

Here's the code that adds the date to the non-blank cell:

Please Login or Register  to view this content.

I've attached a sample workbook. The proof would be to change the number in F4 (yellow), close the workbook, open it, and the next cell will be filled in in Column B. Ideally then, if you don't change the number, save it, close it, open it, it would not have added the next since the number did not change.

Thanks in advance!

Thanks for the help!!!

Thanks for the positive feedback, glad we were able to help.