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

#### astemme

=round(average(Week1:Week4!E2:E24),2) is in worksheet 4 when I move it to worksheet 5 should be Week2:Week5

Solution
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.

#### Alabalcho

##### Judicious
Make a "master" sheet where all these averaged are calculated.

#### astemme

Can you give me an example?

#### Alabalcho

##### Judicious
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.

Replies
6
Views
2K
Replies
0
Views
3K
Replies
0
Views
804
Replies
0
Views
1K
Replies
3
Views
2K