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 A:Date 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