Hello all!
I will try to explain in a clear way my problem. I have to copy and paste from one sheet to another a big number of cells not consecutive.

For example: sheet 1, A1:A7000, I have to copy cells A1,A10,A20,A30... until 7000 from sheet 1 to sheet 2. In the sheet 2 those cells should be consecutive, therefore A1=A1, A10=A2 etc..
I tried to use the offset function but it does not work because it starts from A1 and copy A10, but after it does not start from A10 and copy A20 but it starts from A2 and it copies A11.

I hope I was clear enough!

Thanks to all!

Lina