Thread
:
Help with changing formula
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Help with changing formula
glad it helped
--
Don Guillett
SalesAid Software
"Brad K." wrote in message
...
Thanks Don!!! This was exactly what I needed.
BradK
"Don Guillett" wrote:
a macro
Sub getsum1()
Range("A8").Formula = _
"=SUM('" & Worksheets(2).Name & ":" & _
Worksheets(Worksheets.Count - 1).Name & "'!A8)"
End Sub
--
Don Guillett
SalesAid Software
"Brad K." wrote in message
...
I have a workbook that will be used by several others. I need to find
a
way
to get totals from each sheet and add them together on the "Overview"
sheet.
For example, on Overview sheet Cell C5 might have
='Account1!AF100+'Account2'!AF100+'Account3'!AF100 +'Account4'!AF100
The issue I am having is that each user of this sheet will have a
different
number of "Account?" sheets and there will be no naming consistancy as
they
would put the actual account name for the sheet name.
Is there a way to simply do this or else what is the best
programatically
way to accomplish this?
Thanks,
BradK
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]