Cut data to another worksheet

[LDJB]

I am trying to write a simple piece of code to move data from one worksheet to another. using the data below how would I move the rows where the make is GMC? Would I need to do a loop?

Make Model Classification
Buick LeSabre Car
Buick Park Avenue Car
Cadillac Catera Car
Cadillac DeVille Car
Cheverolet Camaro Car
Cheverolet Express 2500 Van/Minivan
Cheverolet Express 3500 Van/Minivan
GMC Safari Van/Minivan
GMC Savanna 1500 Van/Minivan
GMC Savanna 2500 Van/Minivan
GMC Sierra 3500 Truck
Oldsmobile Achieva Car
Oldsmobile Bravada Suv
Oldsmobile Cutlass Car
Oldsmobile LSS Car
Oldsmobile Regency Car
Oldsmobile Silhoutte Van/Minivan

 

[Jon von der Heyden]

Hi,

Look at Richards solution that did away with my loop. You could adapt to filter anything that contains GMC, and copy instead of delete.

http://www.mrexcel.com/board2/viewtopic.php?t=192430