Hi.
I am working with reports I run off a database, and I need to try to keep track of the new additions to the lists after I run them about twice a month. (I wish this database was more dynamic and there was a better way to keep track than running static reports all the time!)
My question is: Is there a way to delete any dupilacate rows after I copy and paste from the previous report? It would be so helpful to be able to identify any new entries since the last report.
Here is an example of what I am working with....
The rows in red font are the newest report, the rows in black font are from the old report. Having the old data there, with the new data highlighted somehow would be ideal, but not nessisary. Deleting all the old data and only leaving the new data listed is just fine.
Any ideas?
Thanks so much!!
~Drea567
I am working with reports I run off a database, and I need to try to keep track of the new additions to the lists after I run them about twice a month. (I wish this database was more dynamic and there was a better way to keep track than running static reports all the time!)
My question is: Is there a way to delete any dupilacate rows after I copy and paste from the previous report? It would be so helpful to be able to identify any new entries since the last report.
Here is an example of what I am working with....
Discon_8-29-06.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | 2575 | 5"HANG.TIN VOTVE.PUMPKN.X3 | H | 102 | 4 | EA | 12 | 72 | ** | |||
2 | 2847 | 24"FIBER OPTIC"TWIG"TREE | H | 96 | 12.5 | EA | 4 | 24 | ** | |||
3 | 2847 | 24"FIBER OPTIC"TWIG"TREE | H | 96 | 12.5 | EA | 4 | 24 | ** | |||
4 | 2875 | 20"HARVEST BERRY"WREATH | H | 46 | 17.5 | EA | 2 | 24 | ||||
5 | 2875 | 20"HARVEST BERRY"WREATH | H | 46 | 17.5 | EA | 2 | 24 | ||||
Sheet5 |
The rows in red font are the newest report, the rows in black font are from the old report. Having the old data there, with the new data highlighted somehow would be ideal, but not nessisary. Deleting all the old data and only leaving the new data listed is just fine.
Any ideas?
Thanks so much!!
~Drea567