Thanks Anne but I am doing the opposite. I am copying from one sheet t
all the other sheets in the workbook.

I have a table of data, with a column which has all the sheets named
and I want to copy the relevant row of data into the sheet with th
corresponding name

--
James
-----------------------------------------------------------------------
JamesM's Profile: http://www.excelforum.com/member.php...fo&userid=1479
View this thread: http://www.excelforum.com/showthread.php?threadid=26424