Yes. I am putting the info into a column and I am pulling it from a row.

Ken

"kraljb" wrote:


Just to clarify what you are looking for: You are looking to have a
formula that in
Row 1 =Sheet2!A1
Row 2 =Sheet2!B1
Row 3 =Sheet2!C1


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=516282