Weekly Sales moved to Master, if match conditions replace existing other wise new line

why are you requiring to call function lastrow for each occurrence in your loop?
also your current code does not count sunday
is that and error or left off on purpose?

Heres my take of the situation
you only need to copy 2 cells from template over to summary so really dont need to over complicate it

your template is a template so the loop will always been the same
1-7 for your seven days....so why not just indicate that in your loop

as your seven days is constant you can use that as a reference point in your loop instead of using offset's and allocating ranges

last row can be just incremented in your loop itself so there is no need to call on it like you did with your function
ie lrow = lrow + 1

Please Login or Register  to view this content.

as i didnt know how your loop worked i just re-coded it from scratch
but all you need to do to amend yours is put some kind of checking mechanism

all i added as a check on the last date to see if it matches the last date on your template
if they match, msgbox already processed
of course you have have more complex's matches to match every day but really do you require it?

now with your weekly thing
so you an extra line with the total down the bottom of each download?

wont be very hard to add extra code into the Else loop