Thread: VB code required to compare/delete data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
  
Posts: 275
Default VB code required to compare/delete data
Hi all,

Can somebody donate some VB code to carry out the following task?

Look at name in cell BC2, check the name in cell BA2 and if is the same
delete the name in BA2 and BC2.
If is different then leave both cells as they are and move onto checking BC3
against BA3
carry this loop thru BC2 : BC40

hope this makes sense and thanks in advance
Reply With QuoteReply With Quote