Automatically add new row each day with the date label in column A

[smockpuv]

I understand this might be a bit much so I apologize in advance. I have a list and I need to add a new row at the start of each new day with the date labeled in the first column. Along with that if its possible to copy the formulas down from other columns in the spreadsheet. The problem is I know pretty much nothing about VBA or how to implement a script. If its not too much to ask could somebody explain how to do this date thing, and how to implement it in my spreadsheet?

On the last sheet of the document I uploaded is where I'm trying to do this. there are a few more columns with formulas that after the new row is added I want the formulas to be copied down to the new row.

[xladept]

Hi smockpuv,

If you're tallking about Sheet1:

Please Login or Register  to view this content.

[smockpuv]

Thank you very much. It looks great, the problem is I don't know how to test it. Is it difficult to explain how to implement this in my workbook?

Okay, I've found out how to implement this in my spreadsheet and it does indeed update column A with the current date. As far as copying the formulas down into the newly created row from the other three columns, is that possible?

[xladept]

Hi smockpuv,

Try what's there now if I didn't have "EntireRow" in the one you tried, then I was still editing it - a great fault of mine

[smockpuv]

I might be missing something but I still don't see EntireRow in the previous post. I do appreciate the help though!

[xladept]

I guess it didn't take:

Please Login or Register  to view this content.

Sorry!

[smockpuv]

Works wonderfully, thank you very much!

[xladept]

You're welcome!

[smockpuv]

So for some reason this isn't adding a new row and doing what it is supposed to be doing. If I open the VBA and click run on the script it does work perfectly, but it doesn't do it automatically at the start of each new day. Is there something I'm missing in order for it to do that?

[xladept]

Hi Smockpuv,

Have you put this in the "ThisWorkbook" module:

Please Login or Register  to view this content.

And you may need to change the program:

Please Login or Register  to view this content.