Hi

Design your app like a database!

All entries are entered on Payments or Transactions or whatever sheet, which
contains a table like
Date, Unit (or Person), Account, Sum, ...

(The Account column is used to identify different transactions and group
them (like Income: selling, services, .., and Outcome: buying, salaries,
taxes, ...)
Additionaly you may have separate sheets, where Units, Accounts etc. are
listed - you can use them as data validation list sources for main input
table.

You can have an unlimited number of different report sheets, where you can
select conditions, and all needed data is displayed through formulas from
input sheet. And you are absolutely free to design those reports as you like
am best.


Arvi Laanemets



"Kemosobe" wrote in message
...
I am using my Excel for a simple bookkeeping program with bill payees on
the
left and months across the top. After input, I found that each cell would
not accommodate more than one amount. I also cannot figure a way for SUM
horizonally without changing everything around and have the months on the
left and payees on top...Is there a way? Please help...