Hi All,
I am trying to create dependend dropdown list in excel. Basically, i have 4 column Company, Agegroup, Members and Area
When I select company name1, i should get all the set of details related to that company. I Used INDIRECR and SUBSTITUTE and it worked for 1st two column. Without macro can i do this or do i need to use macros?
Please help me in solving this.
Thanks in advance
Hi
Take a look, here
http://www.contextures.com/xldataval02.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thnaks.
But i did not get how exactly to do 3rd dropdown list. I have gone through this, but couldnt get. Can you please help me ?
Actually all my dropdown lists are dependent on 1st dropdown.
Then, pls upload a small sample workbook.
netelity.com/all insurance premium.xlsx i have uploaded here
Hope u could see that sheet
...No. I am not able to see it, in that site. Sorry.
here i have uploaded
Hope you are able to see now
Please check that sheet and correct me where i am wrong
Last edited by Mythri Hegde; 04-19-2012 at 09:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks