Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating A Summary Sheet With Information From Several Worksheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating A Summary Sheet With Information From Several Worksheets
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=Consolidate -- Regards, Tom Ogilvy "Tim Leleux" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating A Summary Sheet With Information From Several Worksheets
Great, thankyou Tom
-- Tim "Tim Leleux" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating A Summary Sheet With Information From Several Workshe
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! "Tom Ogilvy" wrote: 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=Consolidate -- Regards, Tom Ogilvy "Tim Leleux" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating A Summary Sheet With Information From Several Workshe
Thanks also to Piyush.
-- Tim "piyush1982" wrote: 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! "Tom Ogilvy" wrote: 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=Consolidate -- Regards, Tom Ogilvy "Tim Leleux" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |