Home |
Search |
Today's Posts |
#1
|
|||
|
|||
View From a drop down list
How do I set up a list and make it so I can choose from a list to veiw only a
certian entrie. Ex. Date Vendor Product Truck # I purchase some product and we enter it this worksheet. but I only want to view all prodcuts bought fr truck #4. The next time I would want to view all the tires we have bought only. |
#2
|
|||
|
|||
if you mean a drop down list...then use:
data/validation...then select list and eithe type in your entries or reference them to another range in that workbook with the list of entities you want "Tyler" wrote: How do I set up a list and make it so I can choose from a list to veiw only a certian entrie. Ex. Date Vendor Product Truck # I purchase some product and we enter it this worksheet. but I only want to view all prodcuts bought fr truck #4. The next time I would want to view all the tires we have bought only. |
#3
|
|||
|
|||
You can use an AutoFilter (DataAutoFilter). There are instructions in
Excel's Help, and he http://www.contextures.com/xlautofilter01.html Tyler wrote: How do I set up a list and make it so I can choose from a list to veiw only a certian entrie. Ex. Date Vendor Product Truck # I purchase some product and we enter it this worksheet. but I only want to view all prodcuts bought fr truck #4. The next time I would want to view all the tires we have bought only. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop Down List | Excel Worksheet Functions |