| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping user-inputted data with pivot table contents
I have a worksheet that contains a pivot table and data that users
input on each row based on the value of a cell on the pivot table. How can this data keyed by the user be kept on the same row as the cell it is being referenced to when the pivot table is refreshed? For example, the pivot table contains: Col1(name) Col(OrderAmt) User-Inputted Data on Col 3 (outside of pivot table) Company A $100 Company on Prohibited Payment List Company B $50 Shipped 12/1/2003 $60 Company rep quit Company C $800 company visit pending Any help is appreciated. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping Adjacent Columns Attached to a Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| I want a macro to save a workbook as a user inputted cell | Excel Discussion (Misc queries) | |||
| Excel VBA - Find User Inputted Variable | Excel Programming | |||
| Keeping original data format in a pivot table | Excel Programming | |||
Threaded Mode
