Hello Excel Forum,
I'm hoping you might be able to assist me with my query. I'm trying to do a VBA that will duplicate values when two cells have the same information. In my attached samples, Sample.xlsb shows what the spreadsheet looks like with the highlighted data, Pink highlighted data means that the information is in both cells and the white data are unmatched data (which will only be in Cell D), in this case cells D & K. Sample1.xlsb shows the finished product where the Pink highlighted data are matched up. Cell D has more data than Cell K in Sample.xlsb, but you will see that it all matches up after I've manually moved the data in Cell K to match the data in cell D. I want to have this done automatically. So I was wondering if there is a way to duplicate the highlighted data in Cell K, to match the highlighted data in Cell D. I want to include all the data from Cell E onward. I hope this query isn't confusing and if it is I hope my Samples shed some light as to what I'm trying to accomplish.
CheerZ!
Wyldjokre69
Sample1.xlsbSample.xlsb
Bookmarks