I have an Excel sheet that displays products but because the products
can be various states I do not want the product names on every row.
eg:

Product 1____ Sold
_______ ____ Cancelled
_______ ____ Ordered

Product 2____ Sold
_______ ____ Cancelled
_______ ____ Ordered

because the product names constantly change the product names are
referenced from another sheet. So, how do I reference the product names
to a list in another sheet so that i can just drag down the references?
eg:
_
Product_List_____Report_sheet_

Product 1____(link to) Product 1
Product 2
Product 3
Product 4____(link to) Product 2

etc


--
gthull644
------------------------------------------------------------------------
gthull644's Profile: http://www.excelforum.com/member.php...o&userid=23794
View this thread: http://www.excelforum.com/showthread...hreadid=374479