VBA Copy Data Script - Overwrite if Date is Same, Else Next Row

I have a VBA script running on a sheet I use to help manage inventory that copies a set of cells from one sheet to another on exit. I need to modify it so that if the wookbook is closed more than once a day, it overwrites the days entry with the newest numbers, as opposed to having multiple entries for the same day. Here is the script I am currently using for reference.

Please Login or Register  to view this content.

Any thoughts? Thanks for your help.

Took a little bit of tinkering and finally realized why my attempt was failing. My error was trying to compare DATE to NOW. I've attached the code I used for reference for others.

Please Login or Register  to view this content.

Hi. can you do inv.history as own excel file stored somewhere on c disk? :confused