Thank you for responding. I am trying to create a shipping list. In my
first column I have a list of items with an indicator for whether to
ship that item or not.

DESCRIPTION SHIP

chair

desk X

table

lamp X


what I would like to do is link this information to my shipping list
based on whether or not there is an "x".

my shipping list should look like this

desk

lamp



I need to create this list into seperate cells so that I can link to
only the ones I need later. Again thank you for your time.
Candy


--
CNA48
------------------------------------------------------------------------
CNA48's Profile: http://www.excelforum.com/member.php...o&userid=28686
View this thread: http://www.excelforum.com/showthread...hreadid=484051