![copy paste list into excel copy paste list into excel](https://cdn.shopify.com/s/files/1/1046/3032/files/proper-case.png)
➤ Select the range of the Product column and press CTRL+C.
![copy paste list into excel copy paste list into excel](https://www.excelcampus.com/wp-content/uploads/2019/02/3-Ways-to-Copy-and-Paste-in-Excel-with-VBA-Macros-640.png)
We have to copy the Product list from the Product column to the Filtered List column. To copy the filter dropdown list of the Product column in the Filtered List column, here we will be using the Remove Duplicates option to remove the duplicate values from the products, and then, the Sort option will arrange the list the same as the dropdown list of the Product column. Method-3: Using Remove Duplicates Option to Copy Filter Drop Down List Read More: Unique Values in a Drop Down List with VBA in Excel (A Complete Guide) The UNIQUE function is only available for Microsoft Excel 365 version. Then UNIQUE will give us the list with unique products and then it will be sorted out by the SORT function.Īfter pressing ENTER, we will get the filter dropdown list of the Product column in the Filtered List column. Here, Table2 is the range of the Product column of Table2, first FALSE is for Return unique rows and the second one is for Return every distinct item. ➤ Now, write the following function in cell E4 to get the unique values from the Product column. ➤ Select the range and click on the My table has headers option, and finally, press OK. Then, the Create Table wizard will appear. Here, we can see the filter dropdown list of the Product column and we will copy the list to the Filtered List column by using the UNIQUE function and the SORT function.įirstly, we will convert the range into a table. Method-2: Using UNIQUE Function to Copy Filter Drop-Down List in Excel Read More: Create Excel Filter Using Drop-Down List Based on Cell Value
![copy paste list into excel copy paste list into excel](https://i.ytimg.com/vi/Vps6oN5Zy80/maxresdefault.jpg)
Then, the Filtered Listwill be sorted and we will get the filter dropdown list copied in the Filtered List column. ➤ Click on the My data has headers option and press OK. ➤ To do the sorting procedure, select the dataset and go to the Data Tab > Sort & Filter Group > Sort Option. ➤ Select the products as a List range and the destination range where you want to have the outputs in the Copy to box and finally press OK.Īs you can see, we have got the list with unique products in the Filtered List column but it has not been sorted yet.
![copy paste list into excel copy paste list into excel](https://www.howtogeek.com/wp-content/uploads/2016/04/04_selecting_paste_names.png)
➤ Check the options Copy to another location and Unique records only. Then, the Advanced Filter wizard will open up. ➤ Go to the Data Tab > Sort & Filter Group > Advanced Option. Our task is here to copy this dropdown list to the Filtered List column and we will do it here using the Advanced Filter option. So, when we click on the filter dropdown symbol we are getting the list sorted from A to Z and moreover, there is no duplicate value. Here, we have the products listed in the Product column, but the products are not sorted properly and some duplicate products like Blackberries, Broccoli remain there. Method-1: Using Advanced Filter Option to Copy Filter Drop-Down List in Excel We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience. We will try to filter it under various criteria so that we have enabled Filter for this dataset and the following methods will demonstrate the ways to copy the filter dropdown list. Here, we have the following dataset containing the list of salespersons’ names and sales values according to the products. 5 Ways to Copy Filter Drop-Down List in Excel