I would appreciate if any can answer me on the following:
I am working on creating a simple accounting program by excel and need to
find out how I can do an auto command for excel to post the (Debit) and
(Credit) sides to their relevant accounts on a separate sheet or book. Taking
into consideration that the double entry sheet consists of too many entries
and various account numbers and amounts. The following is an example:

On one sheet (Double Entry Sheet)

DR. Acc. Num. CR. Acc. Num.
1000 100101 1000 234100

On account sheet:

Acc.Num 100101 credited for $1000

On another account sheet:

Acc. Num. 234100 debited for $1000

Hope this is clear.
Thanks