| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasteing a list without duplicates
I have a list that I wish to copy but upon pasteing I would like any repeated
items in the list not to be copied. Trying to work it out using other VB I've copied for drop down menus but can't seem to get it to work. TIA Matthew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasteing a list without duplicates
That is exactly what Advanced Filter can do under the Data menu. If you want
VB then record a macro while using the filter. Mike F "Matthew Balch" wrote in message ... I have a list that I wish to copy but upon pasteing I would like any repeated items in the list not to be copied. Trying to work it out using other VB I've copied for drop down menus but can't seem to get it to work. TIA Matthew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| How do I use an activecell as coordinates for pasteing? | Excel Programming | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| keep a cell used in a formula constant when pasteing into another. | Excel Worksheet Functions | |||
![Matthew Balch[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
