Creating an average code for all sheets?

[JustOneQuestion]

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!

 

[AliGW]

Have a look at the information Microsoft offers about 3D cell references: https://support.office.com/en-gb/ar...rksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6

 

[JustOneQuestion]

Have a look at the information Microsoft offers about 3D cell references: https://support.office.com/en-gb/ar...rksheets-40ca91ff-9dcb-4ad1-99d2-787d0bc888b6

This works great. The only issue that I am having is when I go to duplicate a sheet, the #D equation does not copy over to the new sheet. Do you know if there is a way to lock the equation?

Thank you for the help!

 

[JustOneQuestion]

Never Mind. I got it.

Thanks!