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!
Last edited by Nctukek; Jul 3rd, 2013 at 08:04 AM.
Reason: Attachment
Re: Basic VBA program for Comparing, Sorting, and Reformating
There you go
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
Reply With Quote
Originally Posted by vbfbryce
