Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compile two different presentations of same data using excel
I compile a report of a group of individuals each month performing various
activities. Using the same data, I would also lke to produce a report for each individual of their activities on a monthly basis showing like a card index. Is there a way of producing both types of report but inputting the data only once? -- Regards Charlie |
#2
|
|||
|
|||
Hi Charlie,
You might want to do some reading up on these data (menu items) Filtered Lists Pivot Tables Subtotals You can use Google web search, and Google group search to find more specific information, but perhaps you can start with these. Excel Tips and Techniques (site index for excel pages) - Debra Dalgleish http://www.contextures.com/tiptech.html for filtered lists, pivot tables Using DataSubtotals, create a table that has just these subtotals, not the hidden detail rows. http://www.contextures.com/xlfaqFun.html#Subtotals for subtotlas Summarizing Data examples http://www.mvps.org/dmcritchie/excel/sumdata.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Charlie" wrote in message ... I compile a report of a group of individuals each month performing various activities. Using the same data, I would also lke to produce a report for each individual of their activities on a monthly basis showing like a card index. Is there a way of producing both types of report but inputting the data only once? -- Regards Charlie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |