ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing two list of data (https://www.excelbanter.com/excel-discussion-misc-queries/199627-comparing-two-list-data.html)

Tixpack

Comparing two list of data
 
I have two worksheets, each with a list of data (they are actually names).

Worksheet A is the cumulative list of all the names. Worksheet B is the
list for 2007. New names will appear in 2007 that are not on the cumulative
list - is there a function I can use to highlight/identify the new names to
the list?

Then I want to add their names to the cumulative list - is there a simple
way to do that or do I have to cut and paste once I am able to identify the
new names?
--
Tixpack


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com