| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy multiple entries and paste without duplicates
I have a column which is a field within an excel spreadsheet. Its
country field denoting country names. I have multiple entries for al the various countries. I want to highlight the the entire column, cop it, but when I paste it I only want to paste each entry once Effectively its like exporting all the possible field entries withou repeating one of them. Example I want to highlight the range A1:A6 Brazil Canada USA Brazil Canada Chile The paste to a new sheet. When pasted it will look like this: Brazil Canada USA Chile I want to be able to highlight the column and have the macro work of the active range. Can anyone help with this? Thank-yo -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy multiple entries and paste without duplicates
Hi
try using 'Data - Filter - Advanced Filter' and check 'Unique values' -- Regards Frank Kabel Frankfurt, Germany I have a column which is a field within an excel spreadsheet. Its a country field denoting country names. I have multiple entries for all the various countries. I want to highlight the the entire column, copy it, but when I paste it I only want to paste each entry once. Effectively its like exporting all the possible field entries without repeating one of them. Example I want to highlight the range A1:A6 Brazil Canada USA Brazil Canada Chile The paste to a new sheet. When pasted it will look like this: Brazil Canada USA Chile I want to be able to highlight the column and have the macro work off the active range. Can anyone help with this? Thank-you --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy multiple entries and paste without duplicates
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple worksheet Copy Paste Macro | Excel Discussion (Misc queries) | |||
| copy once paste multiple places | Excel Discussion (Misc queries) | |||
| I need to copy & paste multiple lines to another workbook? | Excel Worksheet Functions | |||
| How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
| Copy & paste in multiple areas using VBA | Excel Discussion (Misc queries) | |||
![ExcelMonkey[_116_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
