I need to lookup a part number in a "shipment Log" worksheet. It is laid out
with the following column headers: "Part Number" "Aug 1" "Aug 2" "Aug 3"
etc....
If a part has been shipped, there will be a value under the appropriate date
column. This value will be the quantity shipped.
I am trying to find the most recent shipment date and return that date into
a cell in another spreadsheet. Does anyone have any suggestions?