Keimal
04-24-2018, 11:34 AM
Hi all,
I have recently had to create a bunch of excel macros, but there is one that I cannot figure out how to do. I currently have two spreadsheets (there are many from the same workbook) that I want to merge. However, both spreadsheets don't have the same number of columns, and they may contain duplicates.
I've attached an example that includes the two spreadsheets I need to merge (Gate Validation and Gate Names) and the desired output (Updated Gate Validation).
I am not that familiar with VBA so I wanted to see if any of you guys had a good idea of how to do this.
Any help is greatly appreciated!
-Keimal
I have recently had to create a bunch of excel macros, but there is one that I cannot figure out how to do. I currently have two spreadsheets (there are many from the same workbook) that I want to merge. However, both spreadsheets don't have the same number of columns, and they may contain duplicates.
I've attached an example that includes the two spreadsheets I need to merge (Gate Validation and Gate Names) and the desired output (Updated Gate Validation).
I am not that familiar with VBA so I wanted to see if any of you guys had a good idea of how to do this.
Any help is greatly appreciated!
-Keimal