for your request 1 & 2 change last line to Range("S" & c.Row).Value = Range("H"
& c.Row).Value + cIntt
Change letter S to desired column no.
To run macro on larger row select larger rows, i checked & its working...
Cheers!!
On Wed, Jul 2, 2014 at 12:26 AM, Kalpesh Shivdas
wrote:
> Hi
> Thank
Hi
Thank you for spending time for this calculation
Its working well
Can you make some changes
1 interest calculations (macro result) should be in column after
outstanding /advance (last column)
2 for working of interest please considere current interest column figure
also (this may be blank or fig
Hi
last Q, how do you calculate current int. (Pt. 4). E.g. Bill is raised on
5 Jun & payment recd on 8/Jun, so how you cal int, and you said Total int
will be charged in next bill, is it current int only?
Cheers!!
On Tue, Jul 1, 2014 at 1:51 PM, Kalpesh Shivdas
wrote:
> Can anyone help on th
Can anyone help on this
On Jun 29, 2014 6:56 PM, "Kalpesh Shivdas"
wrote:
> Hi Vaibhav
>
> this format is almost fixed means
> first Opening Balance then current bill & the receipt against it then
> interest (calculate by macros) & then closing outstanding/ advance
>
> by experience I know during
Hi Vaibhav
this format is almost fixed means
first Opening Balance then current bill & the receipt against it then
interest (calculate by macros) & then closing outstanding/ advance
by experience I know during the period not more than 3 receipt received
if macros can calculate more than receipt i
Hi
Is this format is fixed or subject to change?
If format is fixed then is if by chance you get more than 3 receipts than
what?
What you want Macro to do? Where you want calculated Interest amount to be
shown in sheet?
Cheers!!
On Sat, Jun 28, 2014 at 12:15 PM, Kalpesh Shivdas wrote:
> Hi
Hi pramod & vaibhav
Thank you for your reply
I am still facing the interest calculation problem
I have mensioned detail explanation in attached file.
Can you please make macros for this calculation
Regards
On Jun 28, 2014 11:27 AM, "Vaibhav Joshi" wrote:
> Did this got resolved at your end
Did this got resolved at your end or do you need help on this?
On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas
wrote:
> Hi Group
>
>
> Can anyone help me on this
>
> Currently I am using (IF) formula for doing this calculation with is
> very long & confusing.
>
> I have four values 1 opening
Can't Understand . What is your Skype ID. for discussed.
Pramod my ID:- Pramodb35
On Sun, Jun 22, 2014 at 2:45 PM, Kalpesh Shivdas
wrote:
> Hi Group
>
>
> Can anyone help me on this
>
> Currently I am using (IF) formula for doing this calculation with is
> very long & confusing.
>
> I have
