(Resolved)Basic VBA program for Comparing, Sorting, and Reformating

[Nctukek]

VBA Example.zipHey guys,

I'm trying to compare a new spreadsheet of data with an old one and figured it would streamline the process if I could automate it via macro. Each spreadsheet has a column of part #'s, I would like to compare the new column of part #'s with the old row to see if the number has been listed before. After the number is compared I would like one of three things to happen. First, if it hasn't been seen before I would like the row containing the new part # to turn yellow. If it has been seen before I would like to check a Y/N column in the old spreadsheet and have the row in the new spreadsheet to turn green if Y and red if N. Finally, I'd like to sort the new spreadsheet by row color to make it easier to process. I've attached a file to show a basic example of what I'll be starting with. I know this is probably really simple stuff for the veteran VBA programmers out there, but I'm basically completely new to VBA and could really use some help! Thanks in advance!