Sheet 1
_____A______B__
1__vendor1__34
2__vendor2__23
3__vendor3__35

Sheet 2
________A___________B_____
1__=Sheet1!A1___ =Sheet1!B1
2__=Sheet1!A2___ =Sheet1!B2
3__=Sheet1!A3___ =Sheet1!B3


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570775