Auto Macro the pulls data from on sheet, prints on another sheet, then deletes information

I've created a log that will keep track of miles driven on 5 cars for the month. Unfortunately, I have never learned how to write macros.

I've attached my file and on the first sheet "INFO FOR WHAT I NEED!" is what I'm looking for.

Basically what I'm looking for is a macro to run the 1st of every month that will take the Overall Total in each vehicles sheet and print the data in the sheet "Monthly Mileage" in the month that just ended.
Example: March 1st will print in February; April 1st will print in March

After the data has been printed the mileage breakdown will need to be deleted.

I also have an extra that I will like but is not needed and that is to count how many time the mileage is recorded for the month and printed on the "Checked out vs. Rec" sheet under the recorded section.

I know this is a lot to me, not really sure about you, but any help is greatly appreciated.

Please Login or Register  to view this content.

Thank you both for the responses. Where would I place this code at in the doc?

Press Alt+F11 to open Visual Basic for Applications.... Click Insert-->Module.... and paste the code in the module window... Save the workbook as "Excel Macro-Enabled Workbook".

Whenever you need to call the macro... Press Alt+F8 and click "Run"

All I can say is wow mike. It is amazing what y'all can do. Works great.

Just wondering but is there a way to make it run automaticly on the first day of the month?