monthly template

**Back2Basic5** · 07-01-2010, 10:15 AM

I have a spreadsheet, hopefully attached.

the data sheet shows the data for a given month. this will be pasted into here at the begining of each month, and so the range for each month could be very different to the last.

the corporate scorecard shehets should show how many applications have been dealt with and how we did.

I am trying to create a templte so that all that has to be done each month is to fill in the data sheet, not all as some columns have formulas in to auto complete.

i'm just not sure on how to get the final answers for some of the desired formulas. please take a look at the spreadsheet and see what i mean, the comments should answer some questions that you may have about my needs.

Any help on this would be amazing.

**Harley2** · 07-01-2010, 10:58 AM

On the Data sheet if you replace the formula in cell "K2" with =(I2-TRUNC(I2))*60 and drag down that would solve the problem on that sheet. I will continue to work the other sheets to see if I can help

**Harley2** · 07-01-2010, 12:27 PM

Adjusted the Named Ranges to fixed length so as the Data tab grows then both ranges need to be extended to cover the full range of the longest column. Adjusted formula on second tab to reflect what i think you wanted it to do. I am attaching the modified file so you can see what was done. I don't think I can help with the third tab maybe one of the other forum members can help.

**Back2Basic5** · 07-02-2010, 10:16 AM

Thanks so much for the help so far Harley - much appreciated.

I will leave it open in the hope that someone else can help with the remaining issues.

Cheers!