| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table as a data collection tool
We recently sent pivot tables to our reps with three year history of several
hundred products (SKU's) and several hundred customers. We asked that they insert a forecast in the Pivot table source data worksheet so we could then rebuild the table to display the history and the forecast. The request confused most of our sales reps who are admittedly not particularly EXCEL SAVVY. They insisted on putting there input in the available cell NEXT to the pivot table data making capturing their forecast data back to the source data labor intensive. Is there a solution to this problem? Is there an MS office product more suited for this task? What is the true meaning of life? -- John Lutes National Sales Manager Weatherby Inc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Cannot Find Pivot Table Tool in Excel 2007 | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Is the Pivot Table the right tool to do? | Excel Worksheet Functions | |||
Threaded Mode
