MickG Intermediate

  • Member since Feb 9th 2014
  • Last Activity:
Posts
220
Points
1,100
Profile Hits
217
  • 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,


    Christos Papagiannis