Macro to shorten a list

J

JGB

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.
 
R

Roger Govier

Mark your range of data
Data>Filter>Advanced 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.
 
J

JGB

Thanks Roger it works a treat

Roger Govier said:
Mark your range of data
Data>Filter>Advanced 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.
Click to expand...
 
Top