Pivottable trauma

  • Thread starter Thread starter didsburyalex
  • Start date Start date
D

didsburyalex

Hi

I'm looking to extract data from a Pivot table to a new spreadsheet, i
order to not have to type huge numbers of formulae.

i'm using the index formula in combination with hte match formul
followed by the getpivotdata formuala.

I am now very stuck can anyone help?

cheers

didsburyale
 
What are you trying extract, why are you using index/match and
getpivotdata, and where are you getting stuck?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
Excel 2002 vs. Excel 2000 3
list items from one table in another table based on value in first table 2
PivotTable lookup 2
GETPIVOTDATA Turn Off 2
help with Index / match 4
getpivotdata error 2
Extract subtotals (averages) from Pivot Table 1

Back
Top