Comparing two sheets and deleting double entries?
Hello,
I would need help with following and hope someone has the answer.
I have a workbook with two sheets.
The first sheet has 5,000 rows with values in.
The second has the same values in, but only 1,000 of that which the first sheet has.
I do not want to sit there like Cinderella and go through each line to delete them in sheet one.
Since Microsoft is so intelligent, I thought that there must be a way to have this done automatically.
Can someone please help me with that?
Thank you
|