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

Then use this code!

Please Login or Register  to view this content.

Steffen Thomsen

Excellent,

This just serves the purpose. I think I should be able to learn quite fast on this forum.

Thanks a ton Steffen.

Kind Regards
Paul

Your welcome!

If the answer was satisfied, then please mark the thread as solved according to the forum rules

Steffen Thomsen

Hi Steffen,

Now the problem is unique. I added few more rows into the Sheet 1 with month May,Jun,Jul and Aug entries.

Then on running the macro, it still generates only 4 sheets from Jan to Apr.

How to adapt the macro to consider the new row entries as well?

Thanks in Advance

Regards
Paul

The code works for more than 4 sheets as it is, have you made any alterations to the code?

Hi Steffen,

Please see the attached template.

I just added few more rows of input data and clicked on the button to run the macro. Still it shows only 4 sheets till Apr and doesn't reflect the new entries of May, Jun,Jul and Aug as can be seen on Sheet 1.


Thanks in Advance

Regards
Paul

Sorry, just missed a thing!

Please Login or Register  to view this content.

Thanks a lot,

Now it works just as expected. Appreciate your helping a novice like me.


Kind Regards
Paul

Hi Steffen,

If you don't mind me asking, the only difference I see here is the initialization of wSheet. Since I am newly exposed to excel programming, can you please help me understand how does that help in getting the data refreshed in Sheet 1 as was the problem earlier?

Thanks in Advance

Kind Regards
Souvick

Hi,

Before each cell evaluation im resetting the variable wSheet, look at this line at the bottom of the code

Please Login or Register  to view this content.

No, it just means that if wSheet is not reset the check at the top for the existence of the sheet doens't work properly