I have copied the following formula from Column C to Column F:
='[ALL GOLFERS.xls]Anderson, C'!$L$34
I have 25 rows each with a different golfer's name in the formula
Is there an easy way to change ONLY the "L" to "M" in that formula for 25 rows?