Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Referencing Column that changes

Status
Not open for further replies.

maytwo

IS-IT--Management
Oct 6, 2010
9
US
I need to get totals from a pivot table onto another sheet but when I refresh the column changes. Is there a way to reference a pivot table column that is not static???
 
What version of Excel are you using?

Do you need to do this in VBA or would a formula in a cell work for you?

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top