Inserting Current Date in First Cell of New Row in Table

**DavidFC** · 01-28-2019, 04:45 PM

I have three tables that track incoming messages. When someone begins filling out a new row they have to enter the current date in the first cell first then go about filling out other cells.
Most of the time they save themselves time by dragging down the current date about as many rows as they thing they'll need except that sometimes they're over and somethimes they're under.
I want the first cell (column A) to auto populate with the current date as soon as the next line in the table is created.

I have a standard Excel Table that autofills in certain cells with formulas, and I would like for the first cell in each row to auto fill with the current date without leaving it as a formula that would change the next day.

Any help would be appreciated.

**billgyrotech1** · 01-28-2019, 05:21 PM

Maybe like this:

=IF(B2<>"", IF(A2="",NOW(),A2), "")

**DavidFC** · 01-28-2019, 06:29 PM

The downside with this function is that the Now() date/time would change with, well, time.

What I need is a macro that will automatically enter the current date as a value as soon as a new row is added to the Excel Table.

**billgyrotech1** · 01-29-2019, 06:49 AM

With the macro in place, anytime you enter something into a cell in column A, the adjacent cell in column B will contain the date and time (formatted to show only the time). If you delete something in column A, then the adjacent cell in column B is cleared, as well.

Note, as well, that you can change the setting for the NumberFormat property to reflect how you want the date to appear. As an example, you could change to a twelve-hour time format by changing "hh:mm:ss" to "h:mm:ss AM/PM".

Please Login or Register  to view this content.

**DavidFC** · 01-30-2019, 06:08 PM

Thanks so much this worked very well.

Inserting Current Date in First Cell of New Row in Table

LinkBack

Thread Tools

Rate This Thread

Display

Inserting Current Date in First Cell of New Row in Table

Re: Inserting Current Date in First Cell of New Row in Table

Re: Inserting Current Date in First Cell of New Row in Table

Re: Inserting Current Date in First Cell of New Row in Table

Re: Inserting Current Date in First Cell of New Row in Table

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Inserting new row in table will auto populate and save current _date

If cell value's change , inserting current date

[SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines

VBA Code for inserting snap shot of current date and time into text box

Inserting current date ( TODAY() ) by inserting another character

Deleting rows older than current date and inserting a new row

[SOLVED] Excel 2003 Inserting current date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions