removeing dublication across to sheets

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

hi all i have two sheets with part no and prices on i need
to be able to cross ref the sheets and remove any rows
that dont have part number the same on both sheets i.e

sheet1
1232 buns
1236 bags
1234 coke

sheet2
1232 buns
12567 footballs
1236 bags
1234 coke

thanks for any help
 
Back
Top