Moving of worksheet data if...

[sharpyoungb]

Good Day,

I have a worksheet that is completed on a weekly basis that I would like to move the incomplete data to the next weeks worksheet automatically. Is this possible with a marco? Column AM of the worksheet indicates completion of the record.

I have attached the file for reference.

Test One.xlsm

I am hoping that this can be done clicking a button on the worksheet.

Thank you, in advance for your help.

BJ

[p24leclerc]

it can be done but what is the naming procedure for the new sheets?
Will you be creating the new sheets or the macro will?
In the case the macro does create the new sheets, you need a naming structure which would be easy to program. something like "2013Wk25".
One way of doing this is to copy the whole sheet and then to delete rows where the data are completed.