Hello everyone!
Complete newbie with a very naive attitude to excel needs help with the following problem:
I have a workbook with three sheets.
One has Invoices, one has PO numbers, one is the Balance sheet.
What I would like is for the balance sheet to auto populate with the data from invoices & po numbers.
example:
i input a new invoice due to be paid on 1st september 2011 for £1000
then i input a new po number due to be paid on 2nd september 2011 for £500
i would want my balance sheet to show:
Date: + or - Amount Reason Balance
1.9.11 + £1000 excel money £1000
2.9.11 - £500 word money £500
for whats it worth, the balance sheet allready works if you type in each line manually. the balance is calculated based on an if statement surrounding the + or - column followed by the amount.
I hope this makes sense to you guys, please let me know if you need more info!
Complete newbie with a very naive attitude to excel needs help with the following problem:
I have a workbook with three sheets.
One has Invoices, one has PO numbers, one is the Balance sheet.
What I would like is for the balance sheet to auto populate with the data from invoices & po numbers.
example:
i input a new invoice due to be paid on 1st september 2011 for £1000
then i input a new po number due to be paid on 2nd september 2011 for £500
i would want my balance sheet to show:
Date: + or - Amount Reason Balance
1.9.11 + £1000 excel money £1000
2.9.11 - £500 word money £500
for whats it worth, the balance sheet allready works if you type in each line manually. the balance is calculated based on an if statement surrounding the + or - column followed by the amount.
I hope this makes sense to you guys, please let me know if you need more info!
