I have a workbook that is used for billing and it looks up overtime rates in another workbook. Essentially, column A is the person's ID number. Column B is the type of pay (regular, holiday, overtime, etc.). Column C is a formula that looks in different places for their rates based on the type of pay.

I am looking for a code that will scroll through each row on each spreadsheet.

If value in "B3" = "overtime", then convert formula to value in "C3"

The concern is that without this macro, if their overtime rate changes then past data that was entered is no longer accurate.

Thanks in advance!