software

Hi, I am trying to prepare an income statement for my co-operative. I have
separate worksheets for the subscriptions of each member together with the
dates and amounts they have paid. I am looking to produce a summary sheet
that can show each individual contribution by each member during any given
month. Currently I am copying each individual transaction - surely there's a
better way?
--
Tim

the better way is to work from a database where you enter the information all
in one place. Then you can easily build your individual sheets or your
summary sheet from that information.

Beyond that, you might look in Data=gt;Consolidate

--
Regards,
Tom Ogilvyquot;Tim Leleuxquot; wrote:

gt; Hi, I am trying to prepare an income statement for my co-operative. I have
gt; separate worksheets for the subscriptions of each member together with the
gt; dates and amounts they have paid. I am looking to produce a summary sheet
gt; that can show each individual contribution by each member during any given
gt; month. Currently I am copying each individual transaction - surely there's a
gt; better way?
gt; --
gt; Tim

Great, thankyou Tom
--
Timquot;Tim Leleuxquot; wrote:

gt; Hi, I am trying to prepare an income statement for my co-operative. I have
gt; separate worksheets for the subscriptions of each member together with the
gt; dates and amounts they have paid. I am looking to produce a summary sheet
gt; that can show each individual contribution by each member during any given
gt; month. Currently I am copying each individual transaction - surely there's a
gt; better way?
gt; --
gt; Tim

This might not be exactly what you are after, but as a follow up, you could
put all the information in one sheet row by row, (instead of the more
intimidating Database suggested by Tom), and create from that a pivot table
to extract the information in a very flexible way.

I personally find Pivot Tables excellent and intuitive to prepare, and easy
to manipulate. Also useful for the end user if it is not you.

Just thought I'd add this dimension from the user's perspective!

quot;Tom Ogilvyquot; wrote:

gt; the better way is to work from a database where you enter the information all
gt; in one place. Then you can easily build your individual sheets or your
gt; summary sheet from that information.
gt;
gt; Beyond that, you might look in Data=gt;Consolidate
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt; quot;Tim Leleuxquot; wrote:
gt;
gt; gt; Hi, I am trying to prepare an income statement for my co-operative. I have
gt; gt; separate worksheets for the subscriptions of each member together with the
gt; gt; dates and amounts they have paid. I am looking to produce a summary sheet
gt; gt; that can show each individual contribution by each member during any given
gt; gt; month. Currently I am copying each individual transaction - surely there's a
gt; gt; better way?
gt; gt; --
gt; gt; Tim

Thanks also to Piyush.
--
Timquot;piyush1982quot; wrote:

gt; This might not be exactly what you are after, but as a follow up, you could
gt; put all the information in one sheet row by row, (instead of the more
gt; intimidating Database suggested by Tom), and create from that a pivot table
gt; to extract the information in a very flexible way.
gt;
gt; I personally find Pivot Tables excellent and intuitive to prepare, and easy
gt; to manipulate. Also useful for the end user if it is not you.
gt;
gt; Just thought I'd add this dimension from the user's perspective!
gt;
gt; quot;Tom Ogilvyquot; wrote:
gt;
gt; gt; the better way is to work from a database where you enter the information all
gt; gt; in one place. Then you can easily build your individual sheets or your
gt; gt; summary sheet from that information.
gt; gt;
gt; gt; Beyond that, you might look in Data=gt;Consolidate
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt; Tom Ogilvy
gt; gt;
gt; gt;
gt; gt; quot;Tim Leleuxquot; wrote:
gt; gt;
gt; gt; gt; Hi, I am trying to prepare an income statement for my co-operative. I have
gt; gt; gt; separate worksheets for the subscriptions of each member together with the
gt; gt; gt; dates and amounts they have paid. I am looking to produce a summary sheet
gt; gt; gt; that can show each individual contribution by each member during any given
gt; gt; gt; month. Currently I am copying each individual transaction - surely there's a
gt; gt; gt; better way?
gt; gt; gt; --
gt; gt; gt; Tim