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?
A workbook is a file which contains any number of worksheets so I'm assuming that you have one workbook with the two worksheets. Thus, in your explanation, do you mean that you have one workbook with two worksheets, one named "Yesterday" and one named "Today"?