Really new to VBA but coming along.

I hope that this hasn't been addressed already in this forum, I looke
but didn't find it ...

The issue I can't resolve is this: I have a shared workbook wit
multiple sheets, essentially counting instances of answers from list
(lots of 'em) across all sheets. These are being summed in my 'summary
sheet (countif). Upon a button event (available on each sheet), I a
posting from the summary to the summary2 sheet ... using th
following:

Sub GetAns()
Sheets("Summary2").Select
Range("D5").Select
Selection.Offset(0, 0)
Application.Sum(Sheets("Summary").Range("D5").Valu e
Sheets("Summary2").Range("D5").Value)
Selection.Offset(1, 0)
Application.Sum(Sheets("Summary").Range("D6").Valu e
Sheets("Summary2").Range("D6").Value)
.+
.+

Long story, but I have Summary (current tally) and Summary2 (tota
tally)

The thought is this - this book is to be shared by 50+ users who wil
update it periodically yet constantly. What I would like to accomplish
essentially, would be to to have 'summary2' as an external closed boo
that accepts the posting from each save from the open books 'summary
sheet ... using vba (ActiveWorkbook.Save) in my GetAns sub ...
basically 'on save, add this value to that value in that book' ...
'that' book will be a running tally of all users answers ...

Sorry, I hope this makes sense ... Can anyone help

--
Message posted from http://www.ExcelForum.com