Hello. Can anyone help me with a Macro that copies a list of data from Sheet 1 to Sheet 2 and then removes duplicates and orders the list by 'Finish Date'.
Please see my data and the output I want.
Data in Sheet 1.
Copy to Sheet 2.
Remove the duplicates from 'Description' column in Sheet 2.
Then order the list by 'Finish Date', oldest to newest in Sheet 2
Thank you
Please see my data and the output I want.
Data in Sheet 1.
Copy to Sheet 2.
Remove the duplicates from 'Description' column in Sheet 2.
Then order the list by 'Finish Date', oldest to newest in Sheet 2
Thank you