I need to create a macro on my spreadsheet which creates a new line with the current date in the first columb. I can create a macro to do this but i have to select the row I want to put it on. What I need it to do is create a new line with date in first columb under the last inserted colum simply clicking the macro button.

Any help is greatly appreciated, the macro is for the Aldos Pump Hyd Oil sheet for the moment and attaching it to each other sheet afterwards.

Also would it be possible to create a macro to insert a new line with date under previous line on more than 1 sheet with 1 button.

Spreadsheet attached:

Oil Stock Spreadsheet - Remake in progress.xlsm