Solved! How do have a formula change as hte worksheet changes,

May 3, 2018
2
0
10
0
=round(average(Week1:Week4!E2:E24),2) is in worksheet 4 when I move it to worksheet 5 should be Week2:Week5
 
It is very hard to create "automatic" forlumales where sheet names are involved. So, create a new sheet, put it in front of the others. In that sheet, put links to a cell(s) in each sheet where raw data exists, then create averages using the data in this single sheet.
 
It is very hard to create "automatic" forlumales where sheet names are involved. So, create a new sheet, put it in front of the others. In that sheet, put links to a cell(s) in each sheet where raw data exists, then create averages using the data in this single sheet.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
M Apps General Discussion 6
H Apps General Discussion 13
U Apps General Discussion 1
M Apps General Discussion 4
N Apps General Discussion 7
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
J Apps General Discussion 2
Z Apps General Discussion 2
S Apps General Discussion 1
C Apps General Discussion 7
S Apps General Discussion 3
B Apps General Discussion 4
M Apps General Discussion 11
indyitguy Apps General Discussion 8
wanamingo Apps General Discussion 1
Christopher Chung Apps General Discussion 4

ASK THE COMMUNITY