Hello,
I am in the logistics field; one task that I have to do daily is compare two automatically populated workbooks (yesterday's and today's) and re-color orders from companies red, yellow, or green based on a ten digit order number. I'd love to build a macro to do that, but I don't know where to start.
For example, in column A of sheet 1 or workbook 1, the number in row 250 could be "1234567890" and the line will be colored green, yellow or red based on a previous decision. I'd like to be able to search for that number (1234567890) in a random row of column A on sheet 2 or workbook 2, and then color that line the same color as the cell/line in sheet 1 or workbook 1, leaving cells without matching numbers with no fill for me to manually color. I definitely don't mind copying and pasting the new workbook into the master workbook to make this work. Is this possible?
Thanks so much for any and all help!
Dan
I am in the logistics field; one task that I have to do daily is compare two automatically populated workbooks (yesterday's and today's) and re-color orders from companies red, yellow, or green based on a ten digit order number. I'd love to build a macro to do that, but I don't know where to start.
For example, in column A of sheet 1 or workbook 1, the number in row 250 could be "1234567890" and the line will be colored green, yellow or red based on a previous decision. I'd like to be able to search for that number (1234567890) in a random row of column A on sheet 2 or workbook 2, and then color that line the same color as the cell/line in sheet 1 or workbook 1, leaving cells without matching numbers with no fill for me to manually color. I definitely don't mind copying and pasting the new workbook into the master workbook to make this work. Is this possible?
Thanks so much for any and all help!
Dan
Last edited:
