I have this report that I need some help with regarding a macro.
I would like this hotkey-based macro to scan a range, find duplicates, then delete the duplicates underneath the first entry, but copy/paste the contents from column F in column F of the first duplicate it found. Using a comma as a seperator if this is possible. The macro would determine duplicates based on columns D, E, F and H.
I have attached a test file as an example.
Thank you so much for the help!