I have a spreadsheet setup for a golf league with multiple sheets, sheet1 is
for input.
Sheet3 & 4 have formulas pulling the information from Sh1. Sh2 pulls
information from Sh3 and Sh4.
Sh1=input, Sh2=league standings(printout), Sh3=team wkly score,
Sh4=individual score & handicaps

Question for Sh2 and problem I have is;
team1 player1's hcp(e4) =TRUNC(Scorecard!W4)
team2 player1's hcp(e5) =TRUNC(Scorecard!W6)

and then,
team1 player 2's hcp(g4) =Trunc(Scorecard!W5)
team2 player 2's hcp(g5) =Trunc(Scorecard!W7)

I would like to beable to drag down this formula "after" changing the
Letter(Column) to X and have the Letter(column) designation change to X
"and" keep the Number(row) designation increasing by 2.

If I change the "W" to an "X" and drag the formula down I'd like it to look
like this for player#1 for each team;
e4 =Trunc(Scorecard!X4)
e5 =Trunc(Scorecard!X6)
e6 =Trunc(Scorecard!X8)
e7 =Trunc(Scorecard!X10)
etc. for 10 teams, 20 players

for #2 player for each team
g4 =Trunc(Scorecard!X5)
g5 =Trunc(Scorecard!X7)
g6 =Trunc(Scorecard!X8)
etc. for 10 teams, 20 players

I have two columns to do this to, team1 player1(e) and team1 player2(g).
I would like to make this change each week for approx. 20 weeks.

Each week we printout a League Standings sheet with everyones current
handicap, team score and placement. The "W" references the handicap for the
individual player based on their weekly scores. Each week there's a new
formula with the additional weeks score added in, so the standings sheet
needs to reference a different cell(column) each week.

I hope that makes sense,
Brad