Macro for saving daily production.

[Aussie1]

Hi everyone. My first hurdle had been solved thanks to Break_Point using "Sumif" commands for my inventory lists. Now onto my second one.

Once again I have attached my file so if you want to see the coding I am using and have suggestions thank you!

As you can see I have 3 sheets so far, Daily Production, Inventory Received and Inventory sheet. Data is being ported over with the sumif commands from the Daily production sheet and the Inventory Received sheet into the Inventory Sheet to help me keep track of parts I am using and receiving. What I am wanting to do now is create a button with a macro somehow that saves all the Data from the daily production sheet keeping it in tact for the Inventory Sheet. And then clears the data fields to start a new day. I want to be able to save this data indefinitely so I can go back and look at previous days productions. I have highlighted the data fields in light blue on the Daily Production Sheet that needs to be cleared.

Thank you!!