Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Dynamic pivot table
Hi,
I really wounder how good Excel really is. I have for some years now worked with a simple worksheet where I register my hours of work for all the prosjects I participate in. In my workbook I have a sheet for all the months in a year where I have a date, project, activty and description column. The last sheet in workbook I have a summary where I calculate my salary based on each month and a total salary. This works fine. What I want is to expand the functionality by making a summary for each month where I calculate all the hours for each project by month. To do this manually I can us a pivot table to get what I want at this current time. However I want to make a dynamic solution so I at any time can go in and see the summary without making a new pivottable. The dynamic pivottable shall show the summary for the current month. This might seem a little complex functionality, but if this really works, I will really bend myself in the dust for Excel and all the fantastic functionalities which is avalable. Anybody have some sort of tips, example or any guidens if this should be possible??? Kind regards, Jon Haakon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
Pivot table from dynamic refreshed pivot table | Excel Worksheet Functions | |||
Dynamic pivot table | Excel Discussion (Misc queries) | |||
Pivot table dynamic Filter | Excel Worksheet Functions | |||
Pivot Table & Dynamic data | Excel Programming |