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 #1 for Sh4 and problem I have is this;
Week1(b4) =('Weekly Input'!C3)
Week2 (c4)=('Weekly Input'!H3)
Week3 (d4)=('Weekly Input'!M3)
As you can see my formula pulls from cells that advance or change by 5 each
week.
How can I drag the cell formulas across the row and have the formula change
(advance) "just" the letter(column) designation (by 5)correctly? If at all
possible.

Question #2 for Sh2 and problem I have is;
team1 play1's hcp(e4) =TRUNC(Scorecard!W4)
team2 play1's hcp(e5) =TRUNC(Scorecard!W6)
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
e4 =Trunc(Scorecard!X4)
e5 =Trunc(Scorecard!X6)
e6 =Trunc(Scorecard!X8)
e7 =Trunc(Scorecard!X10)
etc.
I have two columns to do this to, team1 player1(e) and team1 player2(g).

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