PDA

View Full Version : master detail filtering



pramoc
08-26-2007, 11:49 AM
please refer the attached workbook

sheet1 has has process name and subprocess name.
sheet 2 has required result.

1. i want two comboboxes in sheet3
2. 1st combobox should have values from sheet1 column A which is process name
3. 2nd combobox should have values from sheet1 column B which is sub process column depending upon the value selected in process name


sheet 2 has required result.
please provide code at the earliest
thanks

lucas
08-26-2007, 03:04 PM
You have to do some of the work yourself. If you have any specific questions don't hesitate to post them.
http://www.contextures.com/xlDataVal02.html

p45cal
08-26-2007, 04:00 PM
sheet 2 has required result.
please provide code at the earliest
thanks..and is there anything else Sir requires of the sweatshop?