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

[antexity]

I am trying to figure out a way when inserting a new row (macro button) into my table. I would like A4 (first row) and so forth to always populate the current date. Then tomorrow the existing rows I inserted today, the date doesn't change to the current date. Essentially, historic data stays historic. I can use today() which will give me current date but then tomorrow the values will change when I open the document. If required here is the Module code I have:

Please Login or Register  to view this content.

Thanks so much in advance!

[TMS]

Given that you are using a macro to insert rows, you may as well put a static system date into the cell in the new row using Date ... rather than having =TODAY() as a formula in a column.

Suggest you post a sample workbook so that the concept can be demonstrated.


Regards, TMS

[antexity]

Please see attached I have given a sample.

Not sure I quite understand the Date function on how that will work. Basically, when entering a new row I would like Column A to have today's date populated without changing to next day when opened the following day.

Thanks again.
Sample RPT TMS (2).xlsm

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[antexity]

Please Login or Register  to view this content.

Regards, TMS

Thank TMS, perfect. Added Rep.

[TMS]

You're welcome. Thanks for the rep.