I have a table. In the rows there is a formula that works great to give me a time stamp when data is entered into Column "D".
The problem is, when the table is full and it needs to expand, (type into cell below table), it expands the table by adding a row, but the formatting of the formula does not work for the newly created row.
In this workbook data is ONLY entered by barcode scanner and data input forms.
When you try to enter manually outside of table on row directly below it has same effect (does not work).
01.png
02.png
03.png
You can see the formula for the time goes to 12:00 instead of creating a proper time as above rows.
Maybe, whenever there is data entered into column D it could insert new row BEFORE last row is used? Just a thought..
I tried doing something like this, but it just looped forever.
Thanks in advance.
Chris
Bookmarks