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. |
Comparing List A to List B and add what's missing from List B
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. |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com