Using Autofilter

C

changetires

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

Thanks,

E
 
C

CLR

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
 
C

CLR

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
Click to expand...

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
 
Top