was thinking very hard :
http://www.box.net/shared/ef2i3grkc0dcnj0zlrdc

I posted in the Excel and Macro group but hope that someone in this group
might also be able to assist.

I have a Grade 8 schedule from which I want to generate STATS as it is in the
case with the Grade 9 Schedule, both files in above link

I assume the original workbook is a template (XLT) and so begs to ask
why the 'Stats' sheet isn't the same in the Gr8 workbook as it is in
the Gr9 workbook? If not, why not just copy the sheet to the Gr9
workbook?

BTW, the file you link to is over 9MB. I don't see enough content in
there to cause the file to be that large when it doesn't need to be!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc