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

Hi and welcome



One of the possibilities is explained here

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post