Thinkk I'm more confused now. Sorry.
This is my current code:
The above works fine. What i want to add in is when the 'For' loop is looping round the worksheets, i want it to do a second loop through the cells B31:B99 and look if any of the dates in this loop are in the last 7 days. If there are I want it to add the corresponding value in coulmn E to the total 'lastweek'. After moving through each of the worksheets. the total will then be written to cell N7.
FYI Column B contains dates and column E contains payments in £.
Thanks,
Mark
Bookmarks