Need a script or macro for excel for data comparison. What I need done is Have a program look up data from one spread sheet to another, and come back once the correct data is found, and highlight the cell GREEN, Yellow, or RED depending on results.
Contents Spreadsheet1, and spreadhseet2
Take a serial number off spreadsheet1, and search spreadsheet2 for this number, if the number is found go back to spreadsheet1, and highlight the cell, but it needs to make sure it highlights it the correct color, Green = found the item, and matches person's name Yellow = found the item, but doens't match the persons name RED: item doesn't exist.
40 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön
VBA developer since 1997. You shall have it same day. Can do. Regards, Svet. P.S. By the way, it makes no difference from programming point of view how many rows are being checked.
Hello, ready to help you right now. It will not blink, not moving through worksheets. Just press "Start" button and you will see results after macro finished.