Re: Summing like data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry this post was an accident.


--
Thank You in Advance
Ed Davis
"Stefi" <Stefi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BEEDCA69-BBE0-42F0-9A3B-CEF2EDCCFF49@xxxxxxxxxxxxxxxx
This is another thread, but the answer is that a space has been inserted
manually before and after InVal. VB editor sometimes doesn't recognize &
as
an operator that must be separated by a space from the operands:

ActiveWorkbook.SaveAs ThisWorkbook.Path & "\Backup\Sales\Work\" & inval &
"(" & _
strSH & ")" & Format(Now, " dd-mm-yy hh-mm-ss") & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Stefi


"Ed Davis" ezt írta:

This is now the whole line of code and I am getting a syntax error on the
line.

ActiveWorkbook.SaveAs ThisWorkbook.Path & "\Backup\Sales\Work\"&inval&"("
&
strSH & ")" & Format(Now, " dd-mm-yy hh-mm-ss") & ".xls",
FileFormat:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, CreateBackup:=False

--
Thank You in Advance
Ed Davis
"nba" <nba@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:97D20C62-91F8-4A1F-A960-4CE6D911C846@xxxxxxxxxxxxxxxx
I have data in the following columns:
a b c d e f
g h
date name unit start end booking
payment
balance
01/06/09 John Smith 1 1/10/09 10/10/09 $1000 $100
$900
01/07/09 John Smith 1 1/10/09 10/10/09 $500
$400
15/09/09 John Smith 1 1/10/09 10/10/09 $400
paid
01/04/09 Mary Jane 4 1/11/09 20/11/09 $2000 $1000
$1000
21/05/09 Mary Jane 4 1/11/09 20/11/09 $1000
paid
01/10/09 Fred Mac 2 1/12/09 02/12/09 $200 $200
paid

I need to create a balance sheet for each booking calculating the
amount
outstanding. Each time a payment is made a new line is created showing
the
date and the amount paid. This is then subtracted from the initial
booking
and you are left with the remaining balance owing or the text "paid".

I have tried nested if statements but it is getting too confusing to
sort
it
out as the number of payments can vary from 1 to many payments.

Can you help simplify a formula to solve this problem.






.

Relevant Pages

  • Re: First year of repayment mortgage, WTF!
    ... then the difference is how much capital you've paid off. ... It will also say what your balance was at the start of the year. ... It is the amount outstanding, which *is* partly capital and partly ... payment over the interest charged for that period (which in turn is ...
    (uk.finance)
  • Can This Publication Be Trusted?
    ... Crikey.com.au reported Armstrong received a $500,000 USD down payment ... with the balance to be paid following the event....." ...
    (rec.bicycles.racing)
  • Re: Providiots trying to raise my interest again and rant
    ... Credit cards suck! ... > for unexpected expenses and paid off sooner than ... >> I started with the smallest balance on my cards ... >> making to that card and add it to the payment ...
    (alt.support.stop-smoking)
  • Re: PPMT Function Repost
    ... the computed principal paid should be the same as the original lease amount less the residual. ... For "pmt" I am using the Excel PMT function with residual ... The interest paid in a period is simply the full payment less the principal paid in the period. ... or equivalently: previousBalance - principalPaid ...
    (microsoft.public.excel.worksheet.functions)
  • Re: PPMT Function Repost
    ... In my amortisation the terms of the loan are entered with unsigned values. ... In the interest paid formula that you provided the two FV ... For "pmt" I am using the Excel PMT function with residual ... payment as negative numbers, which differs from PPMT and IPMT. ...
    (microsoft.public.excel.worksheet.functions)