Merge Rows While Maintaining Unique Values

  • Re: Merge Rows While Maintaining Unique Values


    Just to let you know that this code runs fine for me if I comment out everything except the code I provided. I'll take a look at your code to see if I can spot anything and ask if anyone else has any clues.


    Btw just spotted all the rep points -thanks, don't feel obliged to send any more though!


    If you opening all the files in a particular folder it would be more efficient to create a loop for this rather than opening each individually.

  • Re: Merge Rows While Maintaining Unique Values


    Good News! It is currently working. Thanks so much for your help!


    I'd happily take any pointers you're willing to provide regarding cleaning up the code, making if more efficient.
    But at this time it is working, so I can stop eating up your time.
    Again, greatly appreciate your assistance and expertise.

  • Re: Merge Rows While Maintaining Unique Values


    Glad to hear it. That is very mysterious. As to your code, for example the first two blocks could be shortened to

    and the same principles apply throughout.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!