This is for an academic conference program I am working on.

1. After a "Call for Papers" I have an XL sheet containing 400 proposal
submissions for the conference program arranged in columns of "Speaker
Name", "title of Presentation", etc.

2. I also have a second XL sheet containing the 150 proposals that will
be accepted into the conference program. It is a subset of the full list
though it does not contain all the same columns. It does however contain
the columns of "Speaker Name" and "title of Presentation".

Other than doing it manually, is there a way to remove all the rows
contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
XL sheet of those NOT accepted so I can send them regret emails?

I hope I am clear.

Thanks, Jeff

See Chip Pearson's site

http://www.cpearson.com/excel/topic.aspx

Scroll down to the "L" section and see the various topics for working with
lists...............common items, extracting and defining non-common items.


Gord Dibben MS Excel MVP

On Fri, 04 Mar 2011 03:22:20 -0500, "(E-Mail Removed)" <(E-Mail Removed)>
wrote:

>This is for an academic conference program I am working on.
>
>1. After a "Call for Papers" I have an XL sheet containing 400 proposal
>submissions for the conference program arranged in columns of "Speaker
>Name", "title of Presentation", etc.
>
>2. I also have a second XL sheet containing the 150 proposals that will
>be accepted into the conference program. It is a subset of the full list
>though it does not contain all the same columns. It does however contain
>the columns of "Speaker Name" and "title of Presentation".
>
>Other than doing it manually, is there a way to remove all the rows
>contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
>XL sheet of those NOT accepted so I can send them regret emails?
>
>I hope I am clear.
>
>Thanks, Jeff

On 3/4/11 11:37 AM, Gord Dibben wrote:
> See Chip Pearson's site
>
> http://www.cpearson.com/excel/topic.aspx
>
> Scroll down to the "L" section and see the various topics for working with
> lists...............common items, extracting and defining non-common items.
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 04 Mar 2011 03:22:20 -0500, "(E-Mail Removed)"<(E-Mail Removed)>
> wrote:
>
>> This is for an academic conference program I am working on.
>>
>> 1. After a "Call for Papers" I have an XL sheet containing 400 proposal
>> submissions for the conference program arranged in columns of "Speaker
>> Name", "title of Presentation", etc.
>>
>> 2. I also have a second XL sheet containing the 150 proposals that will
>> be accepted into the conference program. It is a subset of the full list
>> though it does not contain all the same columns. It does however contain
>> the columns of "Speaker Name" and "title of Presentation".
>>
>> Other than doing it manually, is there a way to remove all the rows
>> contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
>> XL sheet of those NOT accepted so I can send them regret emails?
>>
>> I hope I am clear.
>>
>> Thanks, Jeff
Thank you. Will do.

Thanks for the feedback.

Don't lose that URL................invaluable.


Gord

On Fri, 04 Mar 2011 12:44:50 -0500, "(E-Mail Removed)" <(E-Mail Removed)>
wrote:

>On 3/4/11 11:37 AM, Gord Dibben wrote:
>> See Chip Pearson's site
>>
>> http://www.cpearson.com/excel/topic.aspx
>>
>> Scroll down to the "L" section and see the various topics for working with
>> lists...............common items, extracting and defining non-common items.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Fri, 04 Mar 2011 03:22:20 -0500, "(E-Mail Removed)"<(E-Mail Removed)>
>> wrote:
>>
>>> This is for an academic conference program I am working on.
>>>
>>> 1. After a "Call for Papers" I have an XL sheet containing 400 proposal
>>> submissions for the conference program arranged in columns of "Speaker
>>> Name", "title of Presentation", etc.
>>>
>>> 2. I also have a second XL sheet containing the 150 proposals that will
>>> be accepted into the conference program. It is a subset of the full list
>>> though it does not contain all the same columns. It does however contain
>>> the columns of "Speaker Name" and "title of Presentation".
>>>
>>> Other than doing it manually, is there a way to remove all the rows
>>> contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
>>> XL sheet of those NOT accepted so I can send them regret emails?
>>>
>>> I hope I am clear.
>>>
>>> Thanks, Jeff
>Thank you. Will do.

On 3/4/11 1:55 PM, Gord Dibben wrote:
> Thanks for the feedback.
>
> Don't lose that URL................invaluable.
>
>
> Gord
>
> On Fri, 04 Mar 2011 12:44:50 -0500, "(E-Mail Removed)"<(E-Mail Removed)>
> wrote:
>
>> On 3/4/11 11:37 AM, Gord Dibben wrote:
>>> See Chip Pearson's site
>>>
>>> http://www.cpearson.com/excel/topic.aspx
>>>
>>> Scroll down to the "L" section and see the various topics for working with
>>> lists...............common items, extracting and defining non-common items.
>>>
>>>
>>> Gord Dibben MS Excel MVP
>>>
>>> On Fri, 04 Mar 2011 03:22:20 -0500, "(E-Mail Removed)"<(E-Mail Removed)>
>>> wrote:
>>>
>>>> This is for an academic conference program I am working on.
>>>>
>>>> 1. After a "Call for Papers" I have an XL sheet containing 400 proposal
>>>> submissions for the conference program arranged in columns of "Speaker
>>>> Name", "title of Presentation", etc.
>>>>
>>>> 2. I also have a second XL sheet containing the 150 proposals that will
>>>> be accepted into the conference program. It is a subset of the full list
>>>> though it does not contain all the same columns. It does however contain
>>>> the columns of "Speaker Name" and "title of Presentation".
>>>>
>>>> Other than doing it manually, is there a way to remove all the rows
>>>> contained in #2 (the accepted proposals) from sheet #1 to create a 3rd
>>>> XL sheet of those NOT accepted so I can send them regret emails?
>>>>
>>>> I hope I am clear.
>>>>
>>>> Thanks, Jeff
>> Thank you. Will do.
Yes it really is loaded with tips.

Thanks again.