Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a list from previously selected list
I am using excel workbooks in collecting data from different clients. But i
happen to do some intermediate cleaning up work before i send out the workbooks to different clients. For example, i can explain my situation as having a shoe catalog (in one spreadsheet) and asking clients to pick the number and variety of shoes (in a second spreadsheet). Shoe Catalog spreadsheet has gender, size, color. I have to do a manual clean up of unwanted gender before i send to the vendor (say i know some vendors dont want kids shoes or womens shoe). this first spreadsheet is hidden & vendor only uses the second spreadsheet. I am thinking there ought to be a way (in the second spreadsheet) so that when the vendor picks up gender, the available sizes shows up (as a drop down list) automatically in the second list. so when he picks up a size, then the available colors shows up as a drop down list. i think it is really a long explanation about my situation. thanks for reading Sara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a drop down list with a multitude of entries selected | Excel Worksheet Functions | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
Last list item selected in a Multi-Select list box? | Excel Programming | |||
Populating dropdown list 2 with data depending upon what was selected in list 1 | Excel Programming |