Hi, not sure this question has been asked before but here goes
Every week I have to compare to lists of data in Excel, the data can be anywhere from 2000 lines to 5000 lines, it becomes tedious!
I had an idea for an app where I would have 2 datasets filled from a database where id have imported both lists.
I don't need to look at the lines that are the same, my interest lies with the differences, my idea was this.
Fill 2 datasets to compare, have the new data compare against the old, if the compare finds that the data is the same, it erases itself, if it is not the same it moves to the next record. This would leave me with only the information that was different. Does this make sense?
Id really appreciate some help as I don't know where to start after building the form and populating the lists. Its the compare code im going to struggle with.
Thank you all
Every week I have to compare to lists of data in Excel, the data can be anywhere from 2000 lines to 5000 lines, it becomes tedious!
I had an idea for an app where I would have 2 datasets filled from a database where id have imported both lists.
I don't need to look at the lines that are the same, my interest lies with the differences, my idea was this.
Fill 2 datasets to compare, have the new data compare against the old, if the compare finds that the data is the same, it erases itself, if it is not the same it moves to the next record. This would leave me with only the information that was different. Does this make sense?
Id really appreciate some help as I don't know where to start after building the form and populating the lists. Its the compare code im going to struggle with.
Thank you all