Pivot and form retrieve data

[Guest]

does anybody know about the way how to retrieve data into pivot table which is locked as form ?
Example: I have the form and I need only to update daily data in cells but in the certain positions, because pivot changes rows after the upate.
How to do it ?
thanx / m68

 

[Debra Dalgleish]

You can use the GetPivotData function to extract specific data. There's
information in Excel's Help files, and a couple of examples here:

http://www.contextures.com/xlPivot06.html