Database type Formulas

[Smejk]

I am trying to use Excel to manage expenses and income from a business.
I have a table that looks like a basic ledger. Columns Aate B:Expense
C:Income D:Balance E:Client F:Hours.

Is it possible to have a sheet display all transactions from a certain
client without having to enter the info in both places?

Which would be easier to have the formulas enter the info in the ledger
from the client sheets, or have the client sheets filled from the
ledger?

Smejk

 

[Guest]

If you explore Filter->AutoFilter on the Data menu, you may find you can
simply and easily display the transactions for individual clients without the
need for additional worksheets. It works by hiding the rows that don't match
the selection criteria you establish. Additionally, the SUBTOTAL() function
recognizes that some rows are hidden and exludes the hidden values from its
results.