tchandler29
New Member
- Joined
- Feb 23, 2016
- Messages
- 3
I have about 15 tabs that are formatted exactly the same, with the exact same formulas in the same place, but all with different numbers.
I have numbers for each month of the year going across cells M10-X10, and Jan-Dec above it in cell M9-X9. I want to have an average function on each sheet in cell M2 that averages the numbers from Jan up to the current month (If it is currently May, then I want the average function to be =Average(M10-Q10), if it is December, I want it to be =Average (M10-X10)).
I have an input tab with all the months that I am using to reference other formulas throughout the sheet (including one to show what the current month is). How do I get each individual sheet to know what months to pick up in the average formula, based on what month I say it is on the input tab? What I've been trying to do is find a way to type each average formula on the input tab, and somehow reference the formula to be used for the current sheet.
Throughout the year I will be adding sheets, so it would be nice to be able to just move & copy a tab and the formula still work for the new numbers on the new tab.
Thanks.
I have numbers for each month of the year going across cells M10-X10, and Jan-Dec above it in cell M9-X9. I want to have an average function on each sheet in cell M2 that averages the numbers from Jan up to the current month (If it is currently May, then I want the average function to be =Average(M10-Q10), if it is December, I want it to be =Average (M10-X10)).
I have an input tab with all the months that I am using to reference other formulas throughout the sheet (including one to show what the current month is). How do I get each individual sheet to know what months to pick up in the average formula, based on what month I say it is on the input tab? What I've been trying to do is find a way to type each average formula on the input tab, and somehow reference the formula to be used for the current sheet.
Throughout the year I will be adding sheets, so it would be nice to be able to just move & copy a tab and the formula still work for the new numbers on the new tab.
Thanks.