VBA code to search multiple columns and delete any duplicate cells (not rows)

I have tried doing this with excel formulas but have reached a point where I dont think I can make it work. I am not experienced using VBA code so any help is really appreciated.

My Excel program (Excel 2010) currently has several columns and each column looks for and pulls data from a specific file on my computer. Then I need to delete any duplicate data entries, count the number of unique entries and track the changes through a chart. I have everything done except I cannot figure out (or find on the internet) a way to search in multiple columns (more than 2) and delete just the duplicate cells. I want to delete the cells in a way where there is one left. For example if the code 12gf is duplicated three time, I want to be left with one 12gf (it doesnt matter what column the original one is left in). Additionally, column length changes and they are not sorted. I have attempted to attach an image of an example file below. Thanks for all the help!


1.PNG

I could do that however, I want to do this automatically and I am not sure how to join the three columns. Online most ways are explained on how to merge columns, but I want to add them together and then check for duplicates. I want to be able to open my spreadsheet and look at my graphs and everything will update automatically. If anyone has a code to combine three columns and then remove duplicates automatically I am open to trying that for sure. Thanks!

Sure thing. An example is attached.

When I use the code with just the example I provided it works. However in my full document I have some other words in different cells and I keep getting an error when i try to use the code in my real workbook. I have attached my full example now. Sorry for not attaching it first, I didnt realize it was necessary that the labels be in the example.

so where is updated workbook?

It is attached in my previous post, essentially I just added my labels back into the workbook where in the first workbook I posted I simplified it to much and just had my data in the document.

That worked except that I got N/A in one cell, I am not sure why any ideas? Attached is my result:

I am still getting this error:

Capture.PNG

Is this an issue of the naming of my sheets and location in the sheets of the data? For example, does this code work no matter where the columns are or do they have to be in the first three columns (a,b,c) etc... Thanks

That Worked thank you! Also, I may eventually track several sheets, is it possible to loop this code for as many sheets I have and just change the sheet name/columns etc within each loop?

So for example if I have sheets 1-3 with my data I want to run this code one time and within the code if will look in each sheet and populate sheet 4 with a column of data that has no duplicates.

Thanks for the help I will definitely leave a positive rep.

I am getting the below error:

Capture.PNG

I also want it to come as each sheet having its own column so can I put the following inside the loop and change 1 to i?

[Sheets(Sheets.Count).Columns(i).RemoveDuplicates 1, xlNo]

I am attaching an expanded example workbook, I would like one new sheet that has one column per sheet and those column each have that sheet's list of unique data entries within it

Thats the one! Thanks a ton for your help, I should have thought of the expanded example first and saved us both some time, I learned for next time