View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CrimsonPlague29
 
Posts: n/a
Default Dynamic Ranges--Multiple TableData??

Hello,
I have 4 seperate columns in one worksheet which I have create seperate
pivot tabels for, I would like the columns corresponding to the pivot table
to be dynamic. Do I make seperate Name for each set of data like below or can
I make one Name capturing all the data.
Need one for Customer, Parts, Priority also.

Name: 'CCFeedback'!TableData

Refers To:
=OFFSET(CCFeedback1!$B$3,0,0,COUNTA(CCFeedback!$A: $A),1)

Thanks in advance