Help with daily averaging and automatically adding a worksheet copy?

These probably aren't particularly hard to fix, but they're beyond my abilities unfortunately. I've had help from several wonderful people on this forum in the past creating and refining this workbook that my husband uses for analysis. He wanted to make some changes to it, but I'm having trouble with 2 things:

1. It's supposed to automatically add a new worksheet each week by making a copy of the MASTER worksheet and adding it before the PAY COMM AVE sheet. I deleted that sheet because we don't need it anymore, but that messed up adding the new weekly sheet because it can't be found in "Workbook_Open in ThisWorkbook". I believe it's done through a macro, but I don't see any though other than:

Please Login or Register  to view this content.

Instead of adding a new sheet, automatically named with the dates, it's overwriting the PUNCH AVE sheet.


2. I threw off the averages by deleting some no-longer-needed columns and I'm not sure where the problem is. The PUNCH AVE and SOLD AVE sheets aren't picking up the test data I put in for Steve Junker the last 4 weeks (starting Aug 12th). The only difference is I didn't fill in numbers for Saturday, but the formulas shouldn't hinge on that. It should take the total for the week divided by how many days worked to get the daily average. The daily average columns aren't populating for any of the time periods (last 4 weeks, 3 months, 6 months, 1 year).

Hopefully that all makes sense!
Thanks in advance!!
Amy

Thank you both! Your suggestions solved both issues.

Ok. Now he wants to add in 2 more worksheets for RTT-avail and Chg Time averages.

Which part of the array formula looks at the column to pull the figures from? I see in N3 it references a column by 'counting' columns (ie column E would be 5). But I don't know how it references how many days worked that week or how it ties in with the array formula in F3. I tried to copy them to the new sheets but it's not picking up any numbers, let alone the wrong column. I'd like to know how to troubleshoot this myself so I don't have to post every time I have a small change. Thanks again.

You're right. I'm not sure why it wasn't showing correctly while I had it open. I have all 4 averages sheets working now, and I can see where it's pulling from the weekly totals from N3 and on. Thank you again!!

This workbook has been great the last few years. My husband would like to start tracking a few new averages, and I want to make sure all 6 of the AVE sheets are pulling the right numbers. Can someone please take a quick look and adjust the formulas if necessary? Thanks in advance!!!

Thanks again JeteMc! I put in sample info for the last four weeks and the first 4 AVE sheets look good.
For the EFF AVE sheet, it should show a 4-week daily ave. of 114%, and I need to take out the TTL columns.
For the PRO AVE sheet, the 4-week daily average should be 100%, and I also need to delete the TTL columns.
Thank you in advance!

Sorry I didn't explain that clearly.
For EFF AVE: AJ3:AN3 are correct (1.14 ave for each week, in decimal form). E3 should be 114%. Columns F, H, J, and L should be deleted.
For PRO AVE: AJ3:AN3 are correct (1.0 ave for each week, in decimal form). E3 should be 100%. Columns F, H, J, and L should be deleted.

Yes! That's exactly what I needed. It doesn't need to be divided by the number of days worked. I'm all set now! Thank you again SO much. You're amazing.