Thanx bro.. that was really helpful and cooool thing


i have another problem

i have two difference sheets in excel.. and i need to copy some data from the 2nd sheet to the 1st sheet.. the problem is.. the data i want to copy are Row wise and i want to paste them Column.. and there are not in one range.. i mean for example : A1 B1 D1 H1 K1 and i want to paste them in A1 A4 A5 A8 A10

and each time i want to copy it should copy from the next row i.e A2 B2 D2 H2 K2 and paste them to the same column i.e A1 A4 A5 A8 A10

and all this is done thought a botton... i am not an excel or VB programmer so i am facing some difficulties with it..

thank you in Advance