Create a macro to saves the last line of data into a new book at close of each day and save as " next days date", should be simple enough.