Copy data from some tabs, paste it in one column in another tab and then erase duplicates

Hello Vicente Rojas,

We would LOVE a sample Workbook to see where you want these actions to take place.

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.

Hello Vicente Rojas,

..I know absolutely nothing of VBA, so I would LOVE a little help here

Since you know absolutely nothing of VBA, it would serve no purpose to try and explain to you how you could Code, to accomplish your goal.

May I suggest you try the attached Sample Workbook, and check out all the Code in there.

Hope that helps.

Regards.

Hi Vicente Rojas,

I just cant get the "remove duplicates" to work,...

Does it not work for you, and do you have remaining duplicates?

Regards.