Hi, i have attached a mock up of spreadsheet i am trying to create. I want us to easily be able to see what deliveries we have today when we open the spreadsheet without having to look through it for today's date.
i want it to search the the first column for any entries between today's date and the next 5 days and copy them into a new sheet in date order. I want to it auto update everyday when the spreadsheet is opened. what is the best way to do this?
i want it to search the the first column for any entries between today's date and the next 5 days and copy them into a new sheet in date order. I want to it auto update everyday when the spreadsheet is opened. what is the best way to do this?