I have an excel workbook macro that compares the content of 2 sheets and outputs the differences on a third sheet.? I am a novice to coding and made a few updates to the code.
1.? Only 4 of the six lines from worksheet 1 (GRID_UPDATE) are appearing on worksheet3 (GRID_DIFFERENTIAL).
2.? Items that are supposed to be labeled as 'Added' are appearing as 'Not added.
3.? There is a function? that will remove unnecessary spaces and other items from the excel spreadsheet.? Please make sure this function call works properly.?
## Deliverables
I have included the actual file with good test data.? I have made a few updates to the code you written for the project you completed for me.? Please fix the following:
1.? Only 4 of the six lines from worksheet 1 (GRID_UPDATE) are appearing on worksheet3 (GRID_DIFFERENTIAL).
2.? Items that are supposed to be labeled as 'Added' are appearing as 'Not added.
3.? One of my coworkers created a function that will remove unnecessary spaces and other items from the excel spreadsheet.? Please make sure this function call works.