Auto Entry In Different Workbooks and Worksheets

[aburshd]

Dear brother,
i am running a small furniture store.
i want to know if it is possible to auto entry data to other workbooks?
for example:
when i have made an invoice, it will automatically increase the customer account's receivable balance and decrease the inventory account; after i issue a payment receipt: it will automatically decrease customer account and increase my bank or cash account.
please note that there are multiple customers and each customer has individual file(workbook).
how do i do that?
please let me know the simplest way to do this.
i will be very grateful if you could manage some time to work on my requirement.
i am sorry for my bad english.
thank you in advance.

 

[DavidCoop]

I think you are looking for a full accounting bookkeeping system.

This is possible, but unless you really understand Excel, not advisable.

You would be better off with an Accounting System!

 

[aburshd]

I understand. But i do not need accounting system. its only debit and credit in few accounts. Which i wanted Excel to automatically perform.