Using Autofilter
 

For simplicity lets say I have a list of products on sheet 2 and on
sheet 1 I want to have a filtered pull down list in a cell that will
list these individual products from sheet 2. How do I do that?

Thanks,

Ed


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

Using Autofilter
 

This can be done using Data Validation on the cell on sheet1. Give the
list on sheet2 a RangeName, like MyProductList and use it as the list source
in the Data Validation process.......like, =MyProductList

Post back if you have trouble, and someone will help.....

Vaya con Dios,
Chuck, CABGx3




"changetires" wrote:


For simplicity lets say I have a list of products on sheet 2 and on
sheet 1 I want to have a filtered pull down list in a cell that will
list these individual products from sheet 2. How do I do that?

Thanks,

Ed


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

Using Autofilter
 

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

Using Autofilter
 

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