Posts by eDub

    I have been working on some combining scripts. If the source worksheets contain the SAME columns as each other and as the Master worksheet, this code works:

    However, I have taken this a step further and have source worksheets with some different and some of the same columns. And I now need to combine those into the Master worksheet.

    I have attached the sample worksheet I'm working with. I'm open to either mapping all source to destination columns or more preferably, creating master by looking up columns, if present, put data there and if column not present, adding it to the end... rinse, was, repeat.

    Thanks in advance!