Hi Simora,

I sort of understand what you are trying to do but just have a couple
of questions as its difficult to visualise this type of thing. So you
have lists of invoices on each sheet or is it one sheet per invoice? I
see that your copying one column from the previous week but does this
mean it has the same amount of rows as the new week? When working out
the current invoice totals is this a further column along side the
previous? I suppose what I am trying to say is that I need more
information to get it to work, just in the case of copy this column and
insert on relevant sheet between these columns or something along those
lines. Alternatively email me the file and I will see what I can do.

James