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.