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
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