VBA code to select all data then copy and paste all unique value to another sheet

Hi there,

I am trying to manipulate my data by copying all data within the cell and then copying over the unique rows into another sheet.

My reference numbers will be in column A.

I dont know how to go about it.

Use advanced filter or remove duplicates functions. You do not need a macro for this task. Excel has built-in functions.

Originally Posted by AB33

Use advanced filter or remove duplicates functions. You do not need a macro for this task. Excel has built-in functions.

Thank you for the recommendation but I need to copy the filtered list to a new sheet on a daily basis. So filtering and removing duplicates will be too time consuming for me to do it daily.

If you want a macro solution, please attach an excel book sample.

Please find attached my sample data. I need to copy the data over to another sheet then delete all duplicates. The original data must not be altered with. This is only a sample my original data has over 20000 rows.

Thanks for your help.

The code creates first unique value in to new sheet.