Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to shorten a list
Has anyone got a macro that will find duplicate values/names on a sheet and
copy just one of those values onto a seperate sheet within the same workbook. |
#2
|
|||
|
|||
Mark your range of data
DataFilterAdvanced Filter select Unique values and Copy to Another location and make Copy to Sheet2!A1 Switch on the macro recorder as you carry out this task then invoke the macro each time you wish to use. -- Regards Roger Govier "JGB" wrote in message ... Has anyone got a macro that will find duplicate values/names on a sheet and copy just one of those values onto a seperate sheet within the same workbook. |
#3
|
|||
|
|||
Thanks Roger it works a treat
"Roger Govier" wrote: Mark your range of data DataFilterAdvanced Filter select Unique values and Copy to Another location and make Copy to Sheet2!A1 Switch on the macro recorder as you carry out this task then invoke the macro each time you wish to use. -- Regards Roger Govier "JGB" wrote in message ... Has anyone got a macro that will find duplicate values/names on a sheet and copy just one of those values onto a seperate sheet within the same workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |