how to select values from a column with a check box dynamically

[SrinivasanSugumaran]

Hi Team,

Can i seek your help in getting some suggestions.

I have a excel file with few columns as listed below ( the nbr of rows can be increasing/decreasing every month). The user should be dynamically able to select multiple values in the col. and the relevant data should be considered for output.

Country	Store name	Head count	SAles
UK	Walmart	25	20000
USA	Ikea	45	30000
India	Best Buy	30	50000
UAE	Dominos	77	1000
USA	Walmart	88	25000
India	Ikea	24	12000

The user should be given a provision to select multiple countries & store names and accordingly the data corresponding to it should flow in.

eg
if the user selects country as UK & USA  & store as walmart  then the output data should be as below 

Country	Store name	Head count	SAles
UK	Walmart	25	20000
USA	Walmart	88	25000

if the user selects only country as india then output should be as below 

Country	Store name	Head count	SAles
India	Best Buy	30	50000
India	Ikea	24	12000

[FilipR · Accepted solution]

Try this:

[soniya_26]

This doesn't seem to work for me. Do you have any other alternative for this ? Like a dropdown ? Could you please provide the solution ?