Not sure this is what you're getting at, but if the worksheet is called
'Shirts' (for example) and the lines of data you want are A2:F2. All
you need to do is, in the place you want the data in the other
worksheet, type:

=Shirts!A2

...then just drag the cell along six columns to get along to F2.

Not sure if that helps...maybe, maybe not


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=547768