|ok, my Columns are as follows|
S/N: this is the serial number for the parts.
Last Op:- This cell is automatically filled with the information from my daily report, and tells me what operation was last run on the part, could be any number between 1 and 15.
Last Op Timestamp: This cell is automatically filled from the Daily report, tells me what date the Last Operation listed in the Last Op cell occurred
Start Date: the date the part started moving through operations
Operation 1: what date the part went through operation 1
Operation 2: what date the part went through operation 2,
ETC... out to
Operation 15: what date teh part went through operation 15.
Each Row is a new serial number.
if there is a date already in the operation cell it should be overwritten, as it is possible for a part to be logged going through an operation more than once, and the last time through is the time we need to record
What I have currently is a lookup against a table, looks up the "last op" and returns what column that corresponds to, so all I really need is a macro that looks at the data in cell a, (which contains a cell reference) copy the data in cell b, and paste it into the cell reference contained in cell A.