Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 data sets - choose 1 - return another
Ok after hours of reviewing this website I am going to ask what the most
direct way is to do this. I have created a timecard in excel. Each column has a drop down list - depending on what they choose - it will give them another drop down list in the next column. A (from list box) B (from list box) Manual Data Collect If you choose manual data collect - you get list of manuals Project Definition Doc If you choose proj def doc - you get list of actions Administrative Design If you choose admin des - you get list of items Here is the problem. On the manual list for manual data collect - here is the list: ID Manual Name ADMIN Company Profile and Management AIROPS Saab 340 CFM AIROPS Beech 1900-D CFM I want for them to see either a list box with both the ID and manual name but when chosen the ID populates the cell or a list box with just the manual name but the ID populates the cell depending on what they chose. Since there is data valid in the cell I cannot insert vlookup formula there from what i have tried. I cannot make the cell specific to only these answers because this is a timecard which anything in from the list box in column A can be chosen which could have nothing to do with manual data collect. Any suggestions? I know nothing about VBA - so I havent looked into that option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
Choose Data Source | Excel Discussion (Misc queries) | |||
how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions | |||
LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions |