Copy entire row to new spreadsheet based on specific cell value

[flipyducky21]

Hello,

I am new to VBA programming on excel and I am having a tough time. I need to automatically copy each row the has the word INCOMPLETE onto the next spreadsheet..

I have a sample spreadsheet that I will attach. Thanks for any help!

[alansidman]

Can you clarify which sheets have the data incomplete and which sheets they should be copied to? Is that copied or cut and paste? Please clarify.

[flipyducky21]

Sorry, Please just use the sheets the say Data and Data 2. Data has the Incomplete and copy to Data 2. The other two I was just playing around with. Thanks!

[jolivanes]

Try this. If you need changes, let us know.

Please Login or Register  to view this content.

[jolivanes]

Or you could use AutoFilter

Please Login or Register  to view this content.

[flipyducky21]

THANKS jolivanes! This is exactly what I need. Both solutions worked!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.