Need Macro to check each line of data set for duplicate values

Greetings,

I tried over /r/Excel for help, but with no success, since they find it too hard and time consuming. You can check the thread ( reddit /r/excel/comments/8bgiwl/macro_to_filter_each_line_check_duplicates_make/ )

Because I have no answer for my problems, and I have limited knowledge of VBA, I'm still thinking of ways to make it easier for me to get there.

I have uploaded the Data here: ufile dot io/twymv - still junior here.

My solution to the problem is in Sheet 1. I want to create a loop for every Destination, filter it in first sheet, copy the header and the Destination data, transpose paste in second sheet, sort it on the second column, and apply the formulas next to it - basically they check if they are the same, if positive, then add a very small number, if not, keep it. Then I need to do a second loop, until the cell on D1 is 0. If it is, then copy the column G and paste it on the first sheet. Then move to the next Destination and repeat the process.

Anyone able to help?

Thanks in advance.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Welcome to the Forum, goncalo182,

How to attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.