View Single Post
 
Old 05-11-2018, 03:28 PM
MAD King MAD King is offline Windows 7 64bit Office 2016
Novice
 
Join Date: May 2018
Posts: 1
MAD King is on a distinguished road
Default 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
Reply With Quote