Macro to automatically enter time & date

**mellis123** · 04-12-2011, 01:48 PM

Hi,

I would like to enter a time and date automatically each time data is entered into a row.

for example:

Cells A1:A300 are for data entry, either free text or from a validated list.

I would like the corresponding cells B1:B300 to be automatically be populated with the exact time and date that the cells in column A are populated.

Thanks in advance for your help.........

**6StringJazzer** · 04-12-2011, 02:06 PM

This code goes into the module for the worksheet containing the data:

Please Login or Register  to view this content.

**mellis123** · 04-12-2011, 02:32 PM

Thats great, many thanks for your swift response.

Is there away to cover multiple worksheet changes i.e automatically enter a time in column B when a value is changed in column A, but also for instance put another date and time in column D when a value is entered in column C??

Thanks again

**ChemistB** · 04-12-2011, 03:57 PM

Modify like so

Please Login or Register  to view this content.

**abbiekoh** · 06-15-2012, 10:52 PM

hi guys...

im just new here and i really need your help guys regarding my excel. i am trying to make a tracker of my computer rentals that i can use in my computer shop. i already input some formula and it pretty works. but my problem is that, every time i add an addition rental on the succeeding rows, the time and date of the previous time is always changing in current time. attached here is the example of my spreadsheet.. sorry for the apperance because im just novice in creating this kind of tracker. hopefully you can help me guys.. i owe this one...thanks again...Untitled.jpg

**abbiekoh** · 06-15-2012, 10:54 PM

hi guys...

im just new here and i really need your help guys regarding my excel. i am trying to make a tracker of my computer rentals that i can use in my computer shop. i already input some formula and it pretty works. but my problem is that, every time i add an addition rental on the succeeding rows, the time and date of the previous time is always changing in current time. attached here is the example of my spreadsheet.. sorry for the apperance because im just novice in creating this kind of tracker. hopefully you can help me guys.. i owe this one...thanks again...

Untitled.jpg

hope you guys can help me...i need it so badly...

**arlu1201** · 06-16-2012, 06:44 AM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.