Thread: Summary page
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mb97@bigfoot.com is offline
external usenet poster
 
Posts: 6
Default Summary page

Hi,

I've got a workbook with multiple worksheets. A new sheet is addede
every month.
What I'd like to do is to programatticslly create an aut updating
'summary page' that lists each of the worksheet names and various info
from them e.g. ...

Worksheet Count of Column A Count of Column B Highest in
column C
Oct 05 57 63
28974.26
Nov 05 94 15
36541.44

etc..

one line for each w/sheet...

can anyone point me in the right direction??

TIA