<div>
<div class="content wysiwyg-content">
Hi<br />
I have a master Excel 2010 file of about 10,000 contact names and addresses (each contact on a row) and another Excel 2010 file of about 500 contact names which I need to delete from the master file. The rows in each file contain the same information (Email &amp;&nbsp;Name).<br />
Is there a way that I can use a formula or something to delete the 500 rows from the master list without doing it manually one-by-one?<br />
Some kind of formula which says look for this contact in this file and delete?<br />
I'm not an expert on Excel but maybe someone can help or come up with a solution!<br />
Thanks<br />
Andy
</div>
</div>


Hi
I have a master Excel 2010 file of about 10,000 contact names and addresses (each contact on a row) and another Excel 2010 file of about 500 contact names which I need to delete from the master file. The rows in each file contain the same information (Email & Name).
Is there a way that I can use a formula or something to delete the 500 rows from the master list without doing it manually one-by-one?
Some kind of formula which says look for this contact in this file and delete?
I'm not an expert on Excel but maybe someone can help or come up with a solution!
Thanks
Andy

Is it possible to 'auto-delete' rows of data held in one Excel 2010 file from another Excel file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.