HI everybody ,
I am having a hard ( extremely ) time to solve the following problem , can somebody help me out ?
Consider a sheet divided in two different parts , the datas and the resume .
The datas : numbers Town Name Year
1001 A test1 97
2004 B test1 98
1785 C test2 99
3652 D test4 00
4587 E test6 01
1000 F test7 02
5624 G test3 98
1001 A test4 99
And the resume : three drop down boxes ;
Names ( test1 > test 10 )
Year ( 97 > 02 )
The State ( Alabama > Texas )
I would like to select all datas that complete the chosen criteria in the drop down boxes . Knowing that if the number is
between 1000 2000 > Minesota
2000 3000 > alabama
3000 4000 > jersey
4000 5000 california
5000 6000 florida
6000 7000 texas
Any ideas
Many thanks
David van Dea
I am having a hard ( extremely ) time to solve the following problem , can somebody help me out ?
Consider a sheet divided in two different parts , the datas and the resume .
The datas : numbers Town Name Year
1001 A test1 97
2004 B test1 98
1785 C test2 99
3652 D test4 00
4587 E test6 01
1000 F test7 02
5624 G test3 98
1001 A test4 99
And the resume : three drop down boxes ;
Names ( test1 > test 10 )
Year ( 97 > 02 )
The State ( Alabama > Texas )
I would like to select all datas that complete the chosen criteria in the drop down boxes . Knowing that if the number is
between 1000 2000 > Minesota
2000 3000 > alabama
3000 4000 > jersey
4000 5000 california
5000 6000 florida
6000 7000 texas
Any ideas
Many thanks
David van Dea