Hey guys,
I am not sure if this is possible, but, I am trying to populate a table based on a selection in a Data validation List. I have attached a Sample file showing what I am trying to achieve. The sheet "Data" has a set of data and sheet "Filter" is where I need to have the filtering happen based on "Region". When I select "East" the table should populate all the rows with region "East" and the same should happen for other regions as well. Is this even possible in excel with VBA or something?
Any help is appreciated.
Thanks in advance
VJ
Bookmarks