Check out the screenshot.
I have no idea where to begin with this one. Let me explain what I need.
I need cell E10 to display the SR number of the row based on the following criteria:
1: The oldest date in the "To Repair" column (E)
2: Days in repair (G) is NOT Blank (or >=0)
3: Part Received (M) = "YES"
I am still pretty noobish when it comes to VBA, but I think I have come pretty far with the help of you guys.
Thanks.
Bookmarks