LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
NWO NWO is offline
external usenet poster
 
Posts: 60
Default Comparing two Excel data ranges for chnages...

I have one Excel list with two columns, NAME and GRADE, with about 400
records. This list of data is good for two weks after which time I receive
another Excel list with basically the same data from our Personnel
department. What I wish to do is to compare this new list against the
current list, and highlight any NAME and/or GRADE value differences in the
new list. The changed values on the new list will be used to update our
database. The lists can either be on seperate worksheets or next to each
other

Mark :)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing ranges/arrays asaylor Excel Worksheet Functions 7 June 13th 06 11:53 PM
Comparing ranges: ben simpson Excel Discussion (Misc queries) 1 March 8th 06 04:35 AM
Comparing two data ranges for differences. jason.r.swinehart Excel Discussion (Misc queries) 0 January 12th 06 07:50 PM
How to : Comparing Two Ranges lockwood7 Excel Worksheet Functions 3 August 3rd 05 01:43 PM
i changed a document then saved the chnages, is there anything i . RaHeEL HuSsAIn Excel Discussion (Misc queries) 1 February 24th 05 10:42 PM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"