I have a database that keeps weekly prices for some items. In the past the report filled up from 1 -14 date columns and then started a blank new one after that one was full. The users now want it to be a full sheet that always shows the last 14 dates.

Can you point me to the most efficient code that always test for the last 14 and then copies & pastes it to the report worksheet?