StephenAdms
New Member
- Joined
- Jun 4, 2010
- Messages
- 39
I would like assistance comparing data from D8:D5160 on Sheet2 to D8:D6245 on Sheet1. I'm trying to pull the unique identifier (serial number) from Sheet2's column and try to find it in Sheet1's column. The data in both column D's are not in the same order so it will have to go line by line on Sheet2 and look for each serial number on Sheet1.
If the serial number is present, I would like it to color the entire row grey in Sheet 1 and sort the greyed-out serial numbers to the non-grey from top to bottom respectively.
Thank you for your assistance! I have tried doing it several ways and have not been fruitful. I have also searched the forums but could not find a result.
-- removed inline image ---
If the serial number is present, I would like it to color the entire row grey in Sheet 1 and sort the greyed-out serial numbers to the non-grey from top to bottom respectively.
Thank you for your assistance! I have tried doing it several ways and have not been fruitful. I have also searched the forums but could not find a result.
-- removed inline image ---