Dear expert

i am having an excel file with data validation with multi-selection from drop down.

But my concern is - user needs to select single-single items each time and i want to get all the selection at a time as we are having this functionality in pivot tables that we can multi select items at a time.

Any help will be appreciated

thanks
mg