Hi all,

I'm new to the forum and looking for a little help. I have a spreadsheet that looks like this: -

Company Name Sub Classification Position

Under company name is the list of a bunch of different companies, what I want to is have a seperate master worksheet that I can add the names of companies too. If the master list contains the company name I want it to remove the row from the orginial spreadsheet.

I.E. If Masterspreadsheet Column A contains "Ambition Technology" and the orginial spreadsheet has 5 rows that contain "Ambition Technology" those rows will be deleted.

Is anyone able to help me please? I tried to figure it out myself by looking around online but quickly got confused!

Thanks in advance,
Cheyne