Thread
:
Totalling the same cell across multiple workbooks
View Single Post
#
7
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
Totalling the same cell across multiple workbooks
Also look at Data=Consolidate
--
Regards,
Tom Ogilvy
wrote in message
ups.com...
Thanks, but this looks like it is for several sheets WITHIN a workbook.
I am talking about the same named sheet in different workbooks.
Don Guillett wrote:
=sum(firstsheet:lastsheet!c3)
To do the same for "selected" would require a macro
Sub sumselectedsheets()
On Error Resume Next
For Each sh In Windows(1).SelectedSheets
ms = ms + sh.Range("c3")
Next
MsgBox ms
End Sub
--
Don Guillett
SalesAid Software
wrote in message
ups.com...
I have a template that contains cells for number of hours worked in
several rows and columns. I have many copies of this workbook, one for
each employee. I would like to be able to add the cell C3 (for example)
across all of the workbooks that I select...basically merging them all.
Is there an easy way to do this. I spent an hour searching this forum
using different keywords and haven't found a solution yet. Thanks in
advance for any help you can give.
Jeff Wilson
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy