Hi,

I want to write a macro for copying perticular cell from worksheet1 to
worksheet2 at some specified position only.
for instance: My data will be there only in the row 2 of Worksheet 1. I
want to search which cells contains the value and copy that value in the
row 1 of the worksheet2, but at the same column position. i.e. data of
column a2 (Worksheet 1) will be copied at a1 position in worksheet 2.
b2(Worksheet 1) to b1(Worksheet 2). g2(Worksheet 1) to g1(Worksheet 2)
and so on... If any cell is blank then ignore that.

Thanks,
Sylvia


--
Sylvia
------------------------------------------------------------------------
Sylvia's Profile: http://www.excelforum.com/member.php...o&userid=30300
View this thread: http://www.excelforum.com/showthread...hreadid=502395