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!

Register Log in
  • 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

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???
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
208
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
332
mikrom
mikrom
MattGreer
  • Locked
  • Question
VBA Code Deleting a Column instead of Rows...
Replies
6
Views
157
SkipVought
S
mohamadmh
  • Locked
  • Question
Loop through column a tricky one
Replies
12
Views
183
Andrzejek
Andrzejek
corbinap
  • Locked
  • Question
Do loop to find text and add verbiage if found in another column
Replies
2
Views
100
corbinap
corbinap

Part and Inventory Search

Sponsor

Back
Top