Excel issue (may be limitiation)...I tried to search for solutions but without any luck...I have attached the sample excel file for better understanding.
So, I need to set dropdown list for first 4 columns (Dependable dropdowns), my problem is if I select the region as west then I want only state, ID & code to be displayed for "West" region and if I select particular state then only related other filters should be displayed and update the data fields.
This is just a simple file, I am dealing with 5000+ rows and excel only is my option since this will be distributed. I tried looking up each row for particular value and check duplicates ect....but very slow and not the decent way to do it....
Any help would be greatly apprecaited.