MickG Intermediate

  • Member since Feb 9th 2014
  • Last Activity:
Profile Hits
  • 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