return fields of a cell that it belongs to in pivot table

I'm new here - but this is a programming related section of the forum.. isn't there another forum for instructions on non-coding related topics? =/

my question is definitely a programming related question. I need to know the solution to help on my macro coding.

Well providing the macro coding you're working with would be a good start... Or just better explaining your issue. From what I can tell, you want to know if there's a way to say that the decrease from 7700 to 7000 is your total sales?

Sorry for my ambiguous question. I didn't explain it clearly.

Actually I want to let user to change the values in pivot's data area. The changed value in data area of pivot (eg. Sum of sales) would change the data source of pivot too.

In a simple way, let say user wants to change the sales value of person A in year 2010, 7700 to 7000, any cell changed in worksheet will trigger the worksheet_change() event, which will update the data source.

My problem is, user may change any values in the pivot data area, how could I know the changed value is for person A and year 2010? Is there something like, activecell.pivotfield.name?

Hope it clarifies.

Thanks!

So you want to know if a specific user is making this change? for that you can use...

Excel.Application.UserName

For example;

Please Login or Register  to view this content.

As far as the year 2010, you want to simply know if the user is editing a value under a header of 2010?