Hi,
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,
Code
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
Display More
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.
Best regards
GZ