on 2nd sheet build links back to 1st sheet along the row as normal
then select cells with the links
then Paste Special Transpose

you end up with row formulas etc being convertd down a column


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=400296