Thread: Need data from two sheets putting into another

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!

you could just link the cells.

click on the cell you want the info to go into & press "=" then click on the tab & cell where the info currently is & press "enter".

Hope this helps

Originally Posted by Jamesr571

you could just link the cells.

click on the cell you want the info to go into & press "=" then click on the tab & cell where the info currently is & press "enter".

Hope this helps

Yeh i've tried that but its not quite the slick solution I was looking for because how will excel know what to link to next? an invoice or a PO number? Plus, it wouldn't automatically be in date order or anything. Im convinced there is a better solution out there.