How to delete / delete repeated rows comparing different cells?

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

insert the description of the image here

Possible solutions:

1.

  • scroll with the file Macro Excel1 this pass the data to the file Excel2.
  • avoid inserting the line containing the same information that is already inserted into the file Excel2.

In this solution I thought and create a Macro in the file Excel2 scrolling through all the lines and go comparing their cells. But I don't know if it's the fastest way.

2.

  • restrict file Excel1 to send repeated data to file Excel2

Thank you!

Author: Victor Henrique, 2016-03-04
Source

1 answers

insert the description of the image here

- 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 from sending data already passed to the Excel2 file?

 0
Author: user41819, 2016-03-04 16:36:24