Removing Duplicates in ColA Keep Unique Data in Column AC

Hey Everyone,

I have a table that is used for work. Every so often a .csv data set is copied from a workbook that was exported out of a CRM and gets pasted below the table within the workbook in question. Then duplicates are then combined. However I wanted to added a column to the end of the table to add notes to it. However due to the newer information being combined into the table, a blank cell overwrites the notes cell in the last column when rows are combined. I found this macro which is great for removing duplicates, but I cant for the life of me get it to concatenate data in column AC during the combine process. Can anyone help me add a line to concatenate data in column AC?


Thank you for any help!!!

Please Login or Register  to view this content.

Hey MatrixMan thank you so much for offering your help. I have sunk so much time into this project and still cant wrap my head around it to make it work. If at all possible -- Column B-AA (the new data being combined in should always replace these columns). The prexisting data in columns AB,AC,AD should always remain. Thank you again for your help!

Hey MatrixMan,

Thank you for your time again! It is much appreciated! That makes more sense but I am having issues adjusting the size. I have learned quite alot in the macro space over the course of this project but I still cannot wrap my head around readjusting the size of vVALS. Is there a better macro you could recommend or would you mind helping me readjust it? I found the macro below which I think may be better suited, however the issue I am having with this code, is that instead of clearing the table and pasting the array back into the table, it pastes it into a new sheet titled 'result', then causing me some difficulty getting the values back into the table. Let me know what your thoughts are, on whether I should just use a different macro all together or if I should just resize?

Thank you again for your time! I am still trying to learn how to properly use these types of macros!

Please Login or Register  to view this content.