Thanks again. This is starting to work really well, is there any wa
that if I have data in two tables on sheet two I can have a simila
process which inserts corresponding data in order?
e.g.
(sheet 2)
A 1 B 5
B 3 A 2
A 3 B 1

Producing the table:
(sheet 1)

A 1 2 3
B 5 3 1

Thanks again for your help.


Phi

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=54954