I have a problem at the economy unit that I would be very thankful if you guys could help me solve. The problem is I have an invoice which is divided into a ton of cost centre. I need an easy way to sum the amount for each of the cost centre and then added it another sheet in excel which carry an accountancy order.
The way I look at how it would work out is something like this,
Sheet 2: Column A Column B ======= ======= Cost centre Amount 601 $512 566 $6000 100 $1500 556 $5532 122 $3550 One cost centre appear more than one time on the invoice Sheet1: Accounting entry Cost centre Amount ============ ======== ====== 4121 566 $11532 And so forth
All I would like to have to do is add cost centre and amount in sheet two and accounting entry in sheet one, the rest is for excel to handle
If you find a better way solved this by, feel free to let me know about it.
I am using Office 2000 at the office.