Hi everyone ! I'm pretty new here and I tried to look if the answer was already in the forum but couldn't find it ...
I try to create a VBA program which would check duplicates and generate in an other worksheet the data related to each similar duplicates.
I'll do a quick presentation of my project :
worksheet 1:
______l______________l__________l_________l_________l
_data_l___Duplicates___l___data___l__data1___l__data__l
_data_l___Duplicates___l___data___l__data2___l__data__l
_data_l___Duplicates___l___data___l__data3___l__data__l
worsheet 2
______l____________________l__________l__data1____l_______l
______lEnter the duplicate textl__________l__data2____l_______l
______l____________________l__________l__data3____l_______l
(I hope you will understand what I mean with the example )
So I would like the VBA to detect the number of duplicates and extract all the different data from one column of one duplicate and make them appear in one cell on the other worksheet.
Would that be possible ? and which VBA coding should I use ...
Sorry I'm a true learner...
Thanks for your help and any suggestion