Hi Phil

On sheet2 in cell B1 enter
=VLOOKUP(Sheet1!A:B,2,0)
and copy down as far as required

--
Regards

Roger Govier


"phil2006" wrote
in message ...

Hello,
Can anyone help me to copy a value from one cell to another. My work
is
on sheets 1 and 2. Where I have a text word with a value in the column
next to it I need that value to appear on page two in the column next
to the same text word when I insert it regardless of it's position in
the table and how many times it is repeated.
Thanks

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread:
http://www.excelforum.com/showthread...hreadid=549374