Conditionally Copy rows to new sheet in Excel 2007

Hi,

Try running the code in this workbook and se if it does whats required!

Steffen Thomsen

Originally Posted by Steffen Thomsen

Hi,

Try running the code in this workbook and se if it does whats required!

Steffen Thomsen

Thanks a lot Steffen...

It works as expected.

Only a query..once the sheets are generated and I run the macro once again through a button click, same entry is made on the existing sheets and the data is duplicated.

I mean when I first run the macro, 4 new sheets are generated with 4 months. I then run the macro again, and on the same 4 sheets the rows are repeated.

Anyway I can prevent this, so that if someone clicks the button again and the macro runs, it should delete the existng sheets and generate the new sheets.

Or can you help me add one more macro to delete the existing sheets apart from the main sheet?

Thanks in advance

Regards
Souvick