Highlight the cells in your list on Sheet2, then do INsert Name Define
and type MyProductList in the small window and click OK.

Then go to the cell on Sheet1 where you want the drop-down and left-click
Data Validation Allow: List and in the Source: box, type =MyProductList
OK

Now when you select that cell on Sheet1, a small arrow will pop-up at the
right end of it and clicking on the arrow will display the drop down
list......select one of the items and it will be placed in that cell.........

hth
Vaya con Dios,
Chuck, CABGx3



"changetires" wrote:


Still having a problem cant get it to
anything.......HELLLLLLLLLLLLLLP!!!!


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=552210