Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complicated Table
I have a database of customers, projects and category of projects. I
would like to create a table that would show every project by customer by category. For examples: Category I Category II ….. Customer 1 project a project f project b project g project c Customer 2 project d project h project e Can anybody think of a way of doing this either using one of Excel's existing functions (e.g., Pivot Table), VBA coding or a commercial add-in? I have tried fooling around with Pivot Table with little luck. However, I have been able to create a table for one Customer at the time using the Filter command, but I am hoping that there is simpler way to do this. Any help or advice would be much appreciated. Hman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated Look-Up | Excel Discussion (Misc queries) | |||
Complicated Table Functions | Excel Worksheet Functions | |||
rather complicated table to consolidate | Excel Discussion (Misc queries) | |||
complicated calculation in my pivot table | Excel Worksheet Functions | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel |