Data Validation Drop Down List Multiple Selection Without Duplicates. To make data entry easier you can add an excel data validation drop down list to your worksheet. Go to data data tools data validation.
In the data validation dialog select list in allow list under settings tab select the pivottable list as the source data. Now the data of the list are unique. In the worksheet shown below you can select any month from the drop down list and it overwrites any previous entry in the cell.
To allow multiple selections in a drop down list in excel without repetition private sub worksheet change byval target as range dim oldvalue as string dim newvalue as string application enableevents true on error goto exitsub if target address d 2 then if target specialcells xlcelltypeallvalidation is nothing then goto exitsub.
If you d like to test the block duplicates code you can download the no duplicates in multiple selection excel drop downsample file. The file is in excel 2007 format and is zipped. In the data validation dialogue box within the settings tab select list as validation criteria. Click the data tab and choose data validation from the data validation dropdown in the data tools group.
