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

Attachment 101817Hey 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!

If you can zip it, you can attach it.

Quote:

---

Originally Posted by vbfbryce

If you can zip it, you can attach it.

---

I'm sorry but all I could think is 'If you zip it, they will come...'

I've edited my first post to include the attachment. Thanks for the tip!

There you go

Worked like a charm! Thanks for the help!