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 dat
from the 2nd sheet to the 1st sheet.. the problem is.. the data i wan
to copy are Row wise and i want to paste them Column.. and there ar
not in one range.. i mean for example : A1 B1 D1 H1 K1 and i want t
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 B
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 V
programmer so i am facing some difficulties with it..

thank you in Advanc

--
Mr_Flamenc
-----------------------------------------------------------------------
Mr_Flamenco's Profile: http://www.excelforum.com/member.php...fo&userid=2973
View this thread: http://www.excelforum.com/showthread.php?threadid=49443