JustOneQuestion
New Member
- Joined
- Jul 5, 2016
- Messages
- 19
Hi guys,
I am trying to come up with a macro that will automatically average the data in M3 from all the sheets and place the answer in N3. And I am trying to get a macro that will do this automatically when I create a new sheet.
Right now I am tracking the weekly average of employee hours, this average is placed in cell M3 for each sheet, which represents that week. I would like the total weekly average YTD placed in N3 - for example the equation that I am using now is =AVERAGE('Week 41'!M3,'Week 2'!M3)... and so on. Ideally I would like a macro that will apply this formula in each sheet, and transfer to any new sheet that I create as the year progresses.
Any ideas?
Thank you!
I am trying to come up with a macro that will automatically average the data in M3 from all the sheets and place the answer in N3. And I am trying to get a macro that will do this automatically when I create a new sheet.
Right now I am tracking the weekly average of employee hours, this average is placed in cell M3 for each sheet, which represents that week. I would like the total weekly average YTD placed in N3 - for example the equation that I am using now is =AVERAGE('Week 41'!M3,'Week 2'!M3)... and so on. Ideally I would like a macro that will apply this formula in each sheet, and transfer to any new sheet that I create as the year progresses.
Any ideas?
Thank you!