he places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> ----------
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, August 30, 2012 10:17:10 AM
>
> *Subject:* Re: $$Ex
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, August 30, 2012 10:17:10 AM
Subject: Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel Developer
SalesAid Software
d
Your method of looping is inefficient when compared to FIND.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dilan De Silva
Sent: Thursday, August 30, 2012 8:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to Calculate a total
Dear Guillett,
Thank for the solution. Your answer is perfect.
I wrote below macro for the same project. However it's not working
properly. I tried to put the sum formula to get the total. I think error is
writing the upper cell reference(e.g:G50).
Do you have any idea about getting the correct ce