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 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
sample file.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
