How to edit the destination location of my current code

Another forum user kindly produced a code for me yesterday that creates a unique list and copies it to another worksheet.

I am having trouble editing the destination location though. It currently copies values in column A, row 2 (Sheet1) to column A, row 2 (Sheet2)- so as to leave headings.

I am trying to get it leave a blank cell in Sheet2 and so paste to A3 instead.

the code is:

Please Login or Register  to view this content.

I have tried changing it in the following way- which does move the data a line down but then also copies the heading from Sheet1, A1 and puts it in Sheet2, A2 where I want the blank to be:

Please Login or Register  to view this content.

Any ideas?

Please Login or Register  to view this content.

Massive thanks AB33 that does alter the destination location.

For some reason it is copying the header across as well now (though I think now it has always been doing that).

Any idea how I might stop that from copying across?

AB33 had just posted that above but thanks Patel- any chance you might have any ideas on my second post?

Originally Posted by strud

For some reason it is copying the header across as well now (though I think now it has always been doing that).

Any idea how I might stop that from copying across?

Strud,
The code should copy a single column in column A. As the code loops from 1, the header would be copied, but on column A, ONLY. Are you saying that the code copies the header in all columns? That is in A,B and so on?

No just column A's header- but ideally I would like it not to do that if this is possible, so that the column is copied from A2 rather than the whole column

If the header is in row 1

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Massive thanks AB33 that works perfectly!