Macro + outline + pick value + insert in different sheet as drop down

[bluej]

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 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:
[TABLE="width: 107"]
<tbody>[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
</tbody>[/TABLE]
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.
below is the outline structure:


outline 1 -
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]fruits[/TD]
[/TR]
[TR]
[TD]Veg[/TD]
[/TR]
</tbody>[/TABLE]

Outline 2-
Fruits have Apple & banana & Veg have carrot & beetroot

outline 3-
Apple has- Bangalore & HYD
Banana has - MUm & Goa
Carrot has chennai & delhi
beetroot has maratahalli & st marks villgae

outline 4 has:
[TABLE="width: 129"]
<tbody>[TR]
[TD]bangalore has:[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 129"]
<tbody>[TR]
[TD]Hyd has:[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar
[TABLE="width: 129"]
<tbody>[TR]
[TD]Mum has:[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
[TR]
[TD]Goa has :[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 129"]
<tbody>[TR]
[TD]Chennai has:

[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
[TR]
[TD]
delhi has:1
[/TD]
[/TR]
[TR]
[TD]Russel market[/TD]
[/TR]
[TR]
[TD]ONG market[/TD]
[/TR]
[TR]
[TD]Vijaynagar[/TD]
[/TR]
[TR]
[TD]Shantinagar[/TD]
[/TR]
[TR]
[TD]ulsoor[/TD]
[/TR]
[TR]
[TD]rajajinagar[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]maratahalli has:[/TD]
[/TR]
[TR]
[TD]street b[/TD]
[/TR]
[TR]
[TD]street c[/TD]
[/TR]
[TR]
[TD]street d[/TD]
[/TR]
[TR]
[TD]street e[/TD]
[/TR]
[TR]
[TD]street f[/TD]
[/TR]
[TR]
[TD]street1[/TD]
[/TR]
[TR]
[TD]st marks village has:[/TD]
[/TR]
[TR]
[TD]street h[/TD]
[/TR]
[TR]
[TD]street i[/TD]
[/TR]
[TR]
[TD]street j[/TD]
[/TR]
[TR]
[TD]street k[/TD]
[/TR]
[TR]
[TD]street l
---------[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
BlueJ

 

[bluej]

Can someone please help!! i am new to macro

 

[samitnair]

ur que is too confusing. can u attach a screenshot of what u want