Comparing List A to List B and add what's missing from List B
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.
|