Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link a cell outside a pivot table to one inside the table
I have a pivot table that users enter data outside the table that is
associated to data inside the table i.e. due dates are entered by users for part numbers inside the table. The table needs to auto re-fresh and needs to be sortable by data inside the table so when this is done I lose the association to the data outside the table. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link a cell outside a pivot table to one inside the table
I have been working on something similar to this using combo boxes. This
should work. You can create a macro to accomplish this using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields ("salesperson name").CurrentPage = ActiveSheet.Range("G3").Value When a user types a salesperson name into cell G3, or which ever you specify, they can run the macro to update the pivot table. You can create a button for them to click and assign the macro to that to make it easier on the users. Hope this helps "GPGTDRVR" wrote: I have a pivot table that users enter data outside the table that is associated to data inside the table i.e. due dates are entered by users for part numbers inside the table. The table needs to auto re-fresh and needs to be sortable by data inside the table so when this is done I lose the association to the data outside the table. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link a cell outside a pivot table to one inside the table
Sorry, I replied to the wrong post. But after reading your message you might
be able to apply this logic to your problem as well. "GPGTDRVR" wrote: I have a pivot table that users enter data outside the table that is associated to data inside the table i.e. due dates are entered by users for part numbers inside the table. The table needs to auto re-fresh and needs to be sortable by data inside the table so when this is done I lose the association to the data outside the table. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I link a cell outside a pivot table to one inside thetable
You can use the GetPivotData function to extract data from a pivot
table. There are instructions in Excel's Help, and he http://www.contextures.com/xlPivot06.html GPGTDRVR wrote: I have a pivot table that users enter data outside the table that is associated to data inside the table i.e. due dates are entered by users for part numbers inside the table. The table needs to auto re-fresh and needs to be sortable by data inside the table so when this is done I lose the association to the data outside the table. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell detail in pivot table | Excel Discussion (Misc queries) | |||
CELL RANGE SELECTION ON EXISTING PIVOT TABLE | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |