Data Validation Query

[Excel Dumbo]

Hello Excel Friends,

I have attached a spreadsheet. I need to insert two drop down boxes i
to the data. Managed to insert one drop down box. But I am not sure ho
to insert the second drop down box.

Please help


Excel Dumb

+-------------------------------------------------------------------
|Filename: DATA VALIDATION QUERY.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=550
+-------------------------------------------------------------------

 

[Spencer101]

Hello Excel Friends,

I have attached a spreadsheet. I need to insert two drop down boxes i
to the data. Managed to insert one drop down box. But I am not sure ho
to insert the second drop down box.

Please help


Excel Dumbo

Here you go. Notes on how to do it are included in the workbook.

S

+-------------------------------------------------------------------
|Filename: Excel Dumbo - DATA VALIDATION QUERY.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=551
+-------------------------------------------------------------------

 

[Excel Dumbo]

Thanks a lot Spencer.

BUt if you notice. There are two drop down boxes . One for the PLAN an
the other for the Month. When I select items from the two boxes , th
desired items are not showing up.

Please advise

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Don Guillett]

Hello Excel Friends,



I have attached a spreadsheet. I need to insert two drop down boxes in

to the data. Managed to insert one drop down box. But I am not sure how

to insert the second drop down box.



Please help





Excel Dumbo





+-------------------------------------------------------------------+

|Filename: DATA VALIDATION QUERY.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=550|

+-------------------------------------------------------------------+

Use b2:c2 for dv dates
use b1:g1 for dv plan
use this formula in i3 copied down

=OFFSET($A$1,ROW(A2),MATCH($I$2,$2:$2,0)-1+MATCH($I$1,$1:$1,0)-2)