Macro To Copy Row Based On Boolean?

[ViralSynergy]

Hello Everyone,
I've been using these forums for quite some time but I am completely stuck, so this is my first post. I'm currently attempting to Copy rows from sheet "A" to sheet "B" based on a Boolean in column A sheet "A".

The Code I have works, but I'm trying to figure out how to modify it so it doesn't sort the data on Sheet A and can be run from Sheet B.

I continue to screw this up and do not know VBA well enough yet. Thank you in advance for any assistance you are able to give me it is much appreciated. Please let me know if I'm not making sense or need to clarify anything I'm trying to do. (Excel 2010 and Windows 7)

Thanks,
VS

Please Login or Register  to view this content.

[JieJenn]

Can you post the file? Kinda lazy to going through the code.

[DGagnon]

Try this out

Please Login or Register  to view this content.

[ViralSynergy]

Sorry, thought I attached it. Very new at attaching files to a forum post. Macros.xlsm

[ViralSynergy]

Try this out

Please Login or Register  to view this content.

It works except it stops once it finds the first FALSE

[JieJenn]

I simplified your code a little bit.

Please Login or Register  to view this content.

[JieJenn]

Ignore my last post. If it stops at the first "FALSE" then

Please Login or Register  to view this content.

[DGagnon]

for some reason i could not do it with out selecting cells, it may not be the most efficent, but this shoudl work for you

Please Login or Register  to view this content.

[ViralSynergy]

Ignore my last post. If it stops at the first "FALSE" then

Please Login or Register  to view this content.

It deletes the Rows with FALSE and creates a new sheet with every execution.

[ViralSynergy]

DGagnon, sorry not yours. You guys are fantastic. I didn't expect this much help so fast, so thank you. I'm testing your code out right now. That was meant for JieJenn

[ViralSynergy]

for some reason i could not do it with out selecting cells, it may not be the most efficent, but this shoudl work for you

Please Login or Register  to view this content.

It works great, I'll try and figure out how to do it without selecting the cells, so thanks a ton.

[JieJenn]

It was still in Advanced Filter Mode. I didn't want to override sheet2 that's all.

Please Login or Register  to view this content.