Don’t have an account yet? Register yourself now and be a part of our community!
Hi and Happy Easter,
I'm new to vba and i was searching for a way to merge duplicate rows and sum value. I have done this with Power Query but i would like to use VBA instead. I found your answer to an older post of nubian "merge duplicate rows and sum value", which is genius, almost exactly what i was looking for, but i would like ask if it is possible to choose which columns to JOIN (i would like to join non contiguous columns) and paste the results to another sheet. Also I can't understand the use of the two times transpose and resize function.
I would appreciate any help/guidance you give me.
Thank again for the excellent work you are sharing with us,