I could not find what I was looking for in other questions so I will try to pose what I need help with here.
I have one sheet that I have columns and rows summing totals from another sheet ... so totals by the week and the location. I now want to create a 7 day average on an existing sheet that I was doing a 5 day average. So at line 471, I've switched from 5 day avg to 7 day avg. I don't want to start a new sheet so hoping i can do it here. I created my first formula - =sum(link to other sheet cell for week and location)/7 and it calculates fine. I did manual formulas all the way across the row for the different locations (for that week). All good.
Now I'd like to find out how to copy down the formula for the row into the next week to grab the next week's data. When I try to do the copy with the + at bottom right, it just copies the cell but does not change the link to the next link in the original sheet. so all I'm seeing is a copy of the row above and not the next week. I can't use the convert to column formula because it will alter my first 470 rows of data that was calculated on a 5 day average, so I wanted to just copy and allow the formula to populate the next line with the next line from the other sheet.
How do I do this without having to manually write formulas for all cells in rows and columns from this point forward?
Does this make any sense to anyone?
TIA 😁
