Gilbert, I posted one possible solution in your other post on this topic:
http://www.microsoft.com/office/comm...94f&sloc=en-us


"Gilbert" wrote:

Hi,

I have workbook with two worksheets. Sheet1 pulls projects with activity
and Sheet1 pulls all the projects with and without activity. What I need is
a formula or macro that compares sheet1 to sheet2 and returns the projects
from sheet2 that do not exist in sheet1. I would like to see those right
underneath the list in sheet1. I'm using excel 2007 and the projects format
is text. Thank you in advance.