Can you write a macro that places a formula in a cell that provides a value off another cell?
Example: If column 1 ="John" then column 3 "=if("column 14" is blank, leave blank, if it has a number in it, subtract 4 from it and place the value in column 3).
Column 1 needs to be able to accept at least 3 names and each name will have a different number to subtract from column 14 if it has a number in it.
I'm sure its simple, however the more I look at it the more lost I become!
Example: If column 1 ="John" then column 3 "=if("column 14" is blank, leave blank, if it has a number in it, subtract 4 from it and place the value in column 3).
Column 1 needs to be able to accept at least 3 names and each name will have a different number to subtract from column 14 if it has a number in it.
I'm sure its simple, however the more I look at it the more lost I become!