copy and paste row if a cell contains

[matlad123]

Hi

I have tried a variety of things but I keep getting errors, so I think im going start from scratch again. I have a sheet that contains about 3000 registrations from vehicles in column A, I want to find about 4 different registrations. For example purposes A111AAA, A222AAA, A333AAA,A444AAA.

I want to copy the data into sheet 2 starting in row 4. I had a piece of vb that did the copy but kept erroring on the paste section.

I am after it entering the data in the next available row, so when I add more data to sheet 1 and run the code it will just add the new lines in the next available row. I need to leave row 1,2,3 clear.

Thanks

 

[Stridhan]

about 4, random registrations?

 

[matlad123]

Sorry, the registration is the data I am looking to get.... I only need to pull the data for 4 vehicles out of about 3000

 

[Stridhan]

Ok, still, 4 random or will they be specified in anyway?

 

[matlad123]

sorry, they will be specified. if for example purposes use A111AAA i can change to the ones i want later