i am a normal staff working in a office....i need you guys help i
this...really...please.....

there are 2 worksheets (worksheet A and worksheet B).

worksheet A:
cell E1 = A
cell E2 = A
cell E3 = B

worksheet B:
cell A1:C1 = A, apple, peach
cell A2:C2 = B, monkey, elephant

my problem is...
can I combine these 2 worksheet in this way:-

If any cell in (worksheet B eg. A1) = (cell E1 & cell E2, worksheet A
copy row A1:C1 worksheet B) and paste to cell F1 & F2 (worksheet A).

In verbal, i need a formula, or programming text which can help me t
copy data from worksheet B and paste next to the same cell in workshee
A.

I hope you guys can understand what I am trying to say... :)

coz I m dealing with 4 thousands of cells which I need to copy an
paste in these ways...so plzz.....help me.....my eyes hurt after doin
that....

many many thanks in advance.....

--
kaichie
-----------------------------------------------------------------------
kaichiew's Profile: http://www.excelforum.com/member.php...fo&userid=1601
View this thread: http://www.excelforum.com/showthread.php?threadid=27479