I have two workbooks, both of them contain sheets with the same names, the workbooks are created by a macro.
The Macro is basically formatting the sheet, it takes a CSV file (generated from a website) saves it and formats it, applying some auto filtering, and moving some of the data onto other sheets in the workbook.
the sheet is a training Matrix, the easiest way to think of it is there are two categories of training the one is populated from the website via the macro the other has to be populated manually. The macro workbook will be created every two weeks but the other information will be populated manually on the latest version of the macro sheet as the information changes.
So I need to merge the data on the previous sheet with the latest sheet.
The problem which I have is there may be names added or deleted between the sheets and I won't necessarily be aware that names have been added (there are a couple of thousand names in the book in total).
How can I go about doing this?
Thanks
The Macro is basically formatting the sheet, it takes a CSV file (generated from a website) saves it and formats it, applying some auto filtering, and moving some of the data onto other sheets in the workbook.
the sheet is a training Matrix, the easiest way to think of it is there are two categories of training the one is populated from the website via the macro the other has to be populated manually. The macro workbook will be created every two weeks but the other information will be populated manually on the latest version of the macro sheet as the information changes.
So I need to merge the data on the previous sheet with the latest sheet.
The problem which I have is there may be names added or deleted between the sheets and I won't necessarily be aware that names have been added (there are a couple of thousand names in the book in total).
How can I go about doing this?
Thanks
