I've written a macro which clears my spreadsheet and takes forward my totals to a new sheet for the following week.
What I can't work out how to do is to get it to also change the date and advance it by one week.
Can anybody help me out?