Export rows to new sheet based on conditions being met

Hi, I wonder if someone can help as my VBA knowledge is a little limited. I’m looking to transfer filtered data from one spreadsheet to another based on some cell values, but then leave the data that did not meet that criteria in the existing spreadsheet. As an example, consider the following data:
Type Make Cost Area ID
Car Toyota 3000 Oxford 46254
Car Toyota 4000 Bristol
Car Nissan 5000 Bath
Car Ford 6000 Cambridge 58778
Van Ford 7000 Oxford
Van Nissan 8000 Bristol 456555
Bike Vauxhall 9000 Bath 55485
Car Ford 10000 Cambridge 5544

If I wanted to export all rows that were both Car in column A and were not blank in column E, how would I do this with VBA code so rows 2,5,9 are exported and removed from the current worksheet and listed in a new worksheet? Any help you can give would be greatly appreciated.

post a sample workbook

Please see attached - thanks

Thanks for that, very helpful. However, this still copies across rows that don't have an ID. I only want rows which have both car, and an ID entered. Is there a small tweak needed?

Thanks.

Try:

Please Login or Register  to view this content.

This has worked perfectly, thanks all.

If you are satisfied with the solutions given don't forget too mark your thread as solved. See Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Originally Posted by alansidman

Thanks John for tweaking the code.
Alan

You're welcome Alan. Seems it worked for him.