Filter / Link Combo Box / Link Lists / code identifier

[dearing]

Hi

I am trying to create a code identifier which produces a string of letters/numbers based on information picked from drop down lists. For example for each heading there is a letter/number against the that particular title (see below)

ID Level 1 ID Level 2 ID Level 3
TT Development A Design 1 Labour
TT Development B Consultancy 2 Staff Costs
TH Construction A Enabling 1 Labour
TH Construction A Enabling 3 Plant

This table currently has over 800 rows. I'd like the user to be able to pick say Development, from the first list which will then filter for the second list to only provide those areas which are within Development - But I require this to be drop down lists/combo boxes not a filter as the user is not to see all the supporting information.

Therefore if the user picks:
Level 1 Level 2 Level 3
Development Design Labour

The code will be displayed
TT - A - 1

I hope that makes sense......
I can produce the last bit which produces the code by a Lookup - but I can't figure out the lists / combo boxes

Your help would be really appreciated

L

 

[Gavona]

Use Data, Validation Lists together with named ranges.

In the first cell (A1, say) refer to a range that contains construction, development etc. (=Level1List)

In the second cell specify the list as =indirect(A1)

thread707-992483 may also help.



Gavin