Originally Posted by
Greg M
Hi there,
Could you post a desensitised version of your workbook so that I can test a proposed solution?
Regards,
Greg M
Hi Greg, I'm not quite sure if I'm following the forum rules by quoting you but here's a sample data I'm using to easily see if the code I'm doing is working properly. This is assuming that header "Gym Name" will be the primary key or connector for these values. As much as I would like to make a workbook as close to the original one, it's sadly Active Directory data and I'm not quite well versed in it. I would like to note that due to time constraint, the part of the code I posted above happens after the "consolidation" button is clicked. That means, when they're consolidated into one sheet it already includes the duplicates and the discrepancies. Then, if by some miracle I would make that desired output work, it should be placed after the consolidation so what the user will see is the "clean" version of it. Although there's no solution for it yet, I appreciate that you took the time to look at my problem as I'm in a rut right now and can't really code to save my life.
For some reason, the attachment doesn't work (maybe because I'm new) so I'll be dropping it this link here: ufile.io/p5xq6cpa (can't format it to url yet as I'm new).
Also, while I was looking for help, I have updated the code as well so the "columnToMatch" variable doesn't look for a number now, instead it looks for 1 column name. I have also put an all caps comment to note where I think this code goes wrong.
Bookmarks