Filtering within a sheet - replicate on a Form

[g0atface]

Hi

I have the following data in a spreadsheet and currently use the auto-filter to filter down from the column "Section" to give me the number IntItemID, so a user would be selecting an option from each of the columns until they got to a unique "Item ID"

The Excel sheet has 3353 seperate IntItemID's, so you can see why its not so user-fredindly at the moment.

I am trying to create a form to allow users to easily get the ItemID when usign a selection of drop downs rather than the auto-filter, i have successfully done a similar thing on another sheet with Data Validation, but only with two variables, not the 6 as show on this sheet.

The section column has only 3 variables, structures, MEICA and Pipework

Any advice would be greatfully received.

Rates_data_entry_v2.xls
	A	B	C	D	E	F	G
4	SECTION	CLASS	GROUP	SUBGROUP	ITEM	UNIT	intItemID
5	Structures	A-PRELIMINARIES	A0-Preliminarieselementsnotstated	A00-Detailofpreliminariesnotstated	A000-Preliminaries		1
6	Structures	A-PRELIMINARIES	A0-Preliminarieselementsnotstated	A00-Detailofpreliminariesnotstated	A001-ManagementFee		2
7	Structures	A-PRELIMINARIES	A0-Preliminarieselementsnotstated	A00-Detailofpreliminariesnotstated	A002-Risk		3
8	Structures	A-PRELIMINARIES	A1-ContracturalRequirements	A10-Detailofpreliminariesnotstated	A100-generally		4
9	Structures	A-PRELIMINARIES	A2-Specifiedrequirements	A20-Detailofpreliminariesnotstated	A200-generally		5
10	Structures	A-PRELIMINARIES	A3-Methodrelatedcharges	A30-Detailofpreliminariesnotstated	A300-generally		6
11	Structures	A-PRELIMINARIES	A4-Provisionalsums	A40-Detailofpreliminariesnotstated	A400-generally		7
12	Structures	A-PRELIMINARIES	A5-Nominiatedsubcontractors	A50-Detailofpreliminariesnotstated	A500-generally		8
13	Structures	B-GROUNDINVESTIGATION	B0-Typeofworknotstated	B00-Detailnotstated	B000-generally		9
14	Structures	B-GROUNDINVESTIGATION	B1-Trialpitsandtrenches	B10-Detailnotstated	B100-generally		10
15	Structures	B-GROUNDINVESTIGATION	B2-Lightpercussiveboreholes	B20-Detailnotstated	B200-generally		11
16	Structures	B-GROUNDINVESTIGATION	B3-Rotarydrilledboreholes	B30-Detailnotstated	B300-generally		12
17	Structures	B-GROUNDINVESTIGATION	B4-Samples	B40-Detailnotstated	B400-generally		13
18	Structures	B-GROUNDINVESTIGATION	B5-Sitetestsandobservations	B50-Detailnotstated	B500-generally		14
19	Structures	B-GROUNDINVESTIGATION	B6-Instrumentedobservations	B60-Detailnotstated	B600-generally		15
20	Structures	B-GROUNDINVESTIGATION	B7-Laboratorytests	B70-Detailnotstated	B700-generally		16
21	Structures	B-GROUNDINVESTIGATION	B8-Professionalservices	B80-Detailnotstated	B800-generally		17
22	Structures	C-GEOTECHNICALANDOTHERSERVICES	C0-Typeofworknotstated	C00-Detailofpreliminariesnotstated	C000-generally		18
23	Structures	D-DEMOLITIONANDSITECLEARANCE	D0-Typeofworknotstated	D00-Detailofpreliminariesnotstated	D000-generally		19
24	Structures	E-EARTHWORKS	E0-Typeofworknotstated	E00-materialnotstated	E000-depthnotstated	m3	20
Item ID finder

 

[g0atface]

12