Microsoft Excel - outline 1 = dropdown in col A, based on this selection, dropdown in col b= outline2

Asked By Blue J on 02-Dec-12 01:36 AM
Hi All,

I have a sheet named "fruit-sheet" in the attached excel, i have 4 outlines (1 to 4) in it. 






i need a macro code  

i need a macro code which does the below: 

1) it should get the values which can be seen when outline is 1 (in this case fruits & veg can be seen.) & these values should be seen in sheet "DSR" as a dropdown in all the cells of column E 

2) it should get the values which can be seen when outline is 2 (in this case apple, bananna, carrot, beetroot can be seen.) these values should be seen in sheet "DSR" as a dropdown in all the cells of column F 
here there is another condition: In DSR sheet, if i select Fruits in col E, the values in the dropdown in col F should be only Apple & Banana 
& if i select Veg in col E, the values ion the dropdown in col F should be only carrot & Veg

3) it should get the values which can be seen when outline is 3 (in this case bangalore, Hyd, mum, goa, chennai,delhi, maratahalli & st marks village can be seen.) these values should be seen in sheet "DSR" as a dropdown in all the cells of column G

here is one more condition: if i select fruits in col E & apple in col F, i should get only values bangaloe & HYD in col G

4)it should get the values which can be seen when outline is 4, these values should be seen in sheet "DSR" as a dropdown in all the cells of column H

one more condition: if i select fruits in col E & apple in col F, bangalore in col G, i should get below values as dropdown in col H:
Russel market
ONG market
Vijaynagar
Shantinagar
ulsoor
rajajinagar
5) if i select fruits in col E & apple in col F, bangalore in col G, Ulsoor in col H, i should get the corresponding row value from "fruit-sheet" (example in this case the row number is 9)

Please let me know if you need any more clarifications from my side.

Please help me out at the earliest.

Thanks,
Blue J
Harry Boughen replied to Blue J on 02-Dec-12 09:52 PM
Hello Blue J,

This file contains an attempt to work the logic of your market selection process.

market_select.zip

Can you check it to see if it is right?  If it is and it is OK to work this way this sort of thing can be adjusted to suit your purpose.  Finding the relevant row number is a bit more complex but there is not much point working on that if the selection logic is not right.

Regards

Harry