I know this is possible but it eludes me

[dtaylor]

Hello All,

I have a file that has (on one sheet) data in col 'a' and col 'b'.

Now 'a' contains a list of managers, so you can have 2 entries or 2,000 for each manager.

'b' has the sales reps under each manager, so each entry is unique.

for this part of the file I have combo box filling with a defined range for 'b' and a lookup formula to show the manager from 'a' in the next cell.

I would like to have two comboboxes but have not been able figure out how to filter the data.

How do you have records of one combobox(sales reps) be dependent upon the selection of a second combobox (manager)?

any assistance would most appreciated!
This message was edited by dtaylor on 2002-08-29 10:24
This message was edited by dtaylor on 2002-08-29 14:47
This message was edited by dtaylor on 2002-08-29 14:50
This message was edited by dtaylor on 2002-08-29 16:40

 

[PaddyD]

see:

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2

Paddy

 

[dtaylor]

thanks paddyd