I have a spreadsheet that has data input into it every day to track daily completions and hours of projects. I am looking for a way to be able to archive (I think that's the right term) the data every day at a certain time (say 11pm) so I can come back and see how much of the project was completed on that day. I have inserted a date and time picker into my spreadsheet. I want to hopefully be able to select a date from the date picker and have excel bring up the completion data from that day so I can see that a project had x data a month ago and had x other data a week ago. I figured I would need some kind of coding in a macro to be able to archive everything day by day, see the value the date picker puts in a cell, and then reference this date value to pull up data for that day.
Is this possible in excel? I know it is a hard problem.
Is this possible in excel? I know it is a hard problem.
