I have a worksheet of
"Loads" that contains a growing list of loads done by drivers. This worksheet grows with new rows daily. I am wanting to have a seperate worksheet called
"New Loads" in the same workbook that only contains the rows from
"Loads" that falls withing a date range.
For example, I want to pull all the rows from worksheet
"Loads" into worksheet
"New Loads" when the worksheet
"Delivery date" falls between worksheet
"New Loads" cell
"start date" and
I also am wanting any data pulled into the
"New Loads" worksheet to overwrite all old date that was previously pulled. So that way the only data in
"New Loads" is data that matches the date range.