Database type Formulas

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

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>

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.

"Smejk" wrote:

>
> 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
>
>
> --
> Smejk
> ------------------------------------------------------------------------
> Smejk's Profile: http://www.excelforum.com/member.php...o&userid=26742
> View this thread: http://www.excelforum.com/showthread...hreadid=399980
>
>