Date - Automatic

[itsmejan24]

Hi. I have a scenario that I need help. Here it is:

I have sheet1 and sheet2

On A1 (Sheet1), I have a macro that when I hit ENTER key after inputting info it will automatically copy it to last empty row on Sheet2 (starting from column A):

Please Login or Register  to view this content.

Now, what I would like to add here is after it got copied to Sheet2, I would like to add the date it is entered (which is current date) automatically on column E(Sheet2). Please help. Thank you again.

Note: The code above is provided to me by one best Excel pro here in this forum. I thank him for that.

[vandan_tanna]

Please Login or Register  to view this content.

[itsmejan24]

thank you very much. It worked.

[royUK]

Just

Please Login or Register  to view this content.