referencing a cell

[Jaredhott]

I have an Excel document with 6 sheets. the first sheet compiles point values for individuals and the other 5 sheets are each a team with the individuals on the team listed with point values. Each week we want to add the points for the week to the first sheet that complies point values. To do this i have been using a simple reference that goes to the team sheet and to the cell that compiles the weeks points for that player. The way the team sheets are set-up, and the way it needs to stay set up, is such that an individual's weekly points will be always in the same column but will be 50 rows below the previous weeks points. (example: john doe week 1 points =sheet4!B50, john doe week 2 points =sheet4!B100, john doe week 3 points = sheet4!B150, etc). Is there a way to add 50 rows to the reference formula and keep the column the same so that i do not have to manually adjust the reference formula for over 65 individuals on the individual point value sheet? Thanks.

 

[JimboP77]

Do you have an example spreadsheet?

 

[Jaredhott]

yes here you go. https://drive.google.com/file/d/1S3JJD6zSxRqUvt-MPNo11fpsI0UZNp50/view