Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting unique values from a list using VBA
Hi there (again),
Another challenge: Is there a way using VBA to extract all the unique values from a source coulmn and paste them to a target column? I know you can do it using autofilter and pivottables but the former is time consuming and the latter inelegant. Thanks Duncan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting unique values from a list using VBA
Yes, it is possible. All you need to do is record a macro while you do
it once, then you can re-run the macro whenever you need it. You may need to edit the macro, once recorded, to enable it to work with variable amounts of data etc. Hope this helps. Pete On Jan 25, 2:45*pm, dangerd wrote: Hi there (again), Another challenge: Is there a way using VBA to extract all the unique values from a source coulmn and paste them to a target column? I know you can do it using autofilter and pivottables but the former is time consuming and the latter inelegant. Thanks Duncan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting unique values from a list using VBA
On Jan 25, 2:49*pm, Pete_UK wrote:
Yes, it is possible. All you need to do is record a macro while you do it once, then you can re-run the macro whenever you need it. You may need to edit the macro, once recorded, to enable it to work with variable amounts of data etc. Hope this helps. Pete On Jan 25, 2:45*pm, dangerd wrote: Hi there (again), Another challenge: Is there a way using VBA to extract all the unique values from a source coulmn and paste them to a target column? I know you can do it using autofilter and pivottables but the former is time consuming and the latter inelegant. Thanks Duncan- Hide quoted text - - Show quoted text - so simple....thx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting unique values from a list using VBA
You're welcome.
Pete On Jan 25, 3:01*pm, dangerd wrote: so simple....thx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting unique values from a list using VBA
Add headers if you need to.
Then use Data|Filter|advanced filter (xl2003 menus) Record a macro when you do it and you'll have the code. Debra Dalgleish explains it he http://www.contextures.com/xladvfilter01.html#FilterUR dangerd wrote: Hi there (again), Another challenge: Is there a way using VBA to extract all the unique values from a source coulmn and paste them to a target column? I know you can do it using autofilter and pivottables but the former is time consuming and the latter inelegant. Thanks Duncan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically extracting unique values | Excel Worksheet Functions | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |