hemant4music
New Member
- Joined
- Mar 29, 2018
- Messages
- 1
Hi all,
My first query here. I am from a development background and lack the VBA know how to get this work done. Any help is much appreciated.
I have 2 spreadsheets, with around 2000 rows of data with 55 columns.
I need to match data between the two sheets based on 10 columns given to me by the business.
Any rows NOT matching on the above 10 columns need to be inserted in the 2nd spreadsheet. I can then sort them and set them to be in the right location within the spreadsheet.
It would be a 5-10 minutes job to do this in SQL with two tables/data-sets. However, I can't get around how best to approach this to make sure
- Any new records that are marked by the above 10 column's comparison, get inserted into the 2nd sheet
- Information in any columns other than the above 10, also gets updated in the 2nd sheet with data from the 1st sheet
- An audit of everytime records are inserted/updated in the 2nd sheet.
My first query here. I am from a development background and lack the VBA know how to get this work done. Any help is much appreciated.
I have 2 spreadsheets, with around 2000 rows of data with 55 columns.
I need to match data between the two sheets based on 10 columns given to me by the business.
Any rows NOT matching on the above 10 columns need to be inserted in the 2nd spreadsheet. I can then sort them and set them to be in the right location within the spreadsheet.
It would be a 5-10 minutes job to do this in SQL with two tables/data-sets. However, I can't get around how best to approach this to make sure
- Any new records that are marked by the above 10 column's comparison, get inserted into the 2nd sheet
- Information in any columns other than the above 10, also gets updated in the 2nd sheet with data from the 1st sheet
- An audit of everytime records are inserted/updated in the 2nd sheet.
