How to delete/delete repeat lines by comparing different cells?

Asked

Viewed 451 times

3

I want to know how to delete a row that is repeat along my table. The image below can help

inserir a descrição da imagem aqui

Possible solutions:

1.

  • Browse with Macro from file Excel1 this pass the dice to the file Excel2.
  • Prevent it from being inserted into the file Excel2 the line containing the same information already inserted.

In this solution I thought and create a Macro in the file Excel2running through all the lines and comparing your cells. I don’t know if it’s the fastest way.

2.

  • Restrict that file Excel1 send repeated data to the file Excel2

Thank you!

excel vba macro

  • Check this link. You can help: http://answall.com/questions/30819/como-crea-uma-macro-do-excel-para-excluir-linhas-duplicated?rq=1

1 answer

0

inserir a descrição da imagem aqui

-Here’s an image to help. -I remembered now also to ask if there is any way to restrict the Macro of the Excel1 file to send data already passed to the Excel2 file?

Browser other questions tagged excel vba macro

You are not signed in. Login or sign up in order to post.