In Excel 2000, it would be similar to this:
=GETPIVOTDATA($A$3,"'Circuits Scrapped' Year 2006 Month 2")
maryj wrote:
Thank you Debra.
Next question - The Getpivotdata function in the Excel 2003 file is
=GETPIVOTDATA("Circuits Scrapped",$A$3,"Year",2006,"Month",2). All of the
examples I have seen using the this function in Excel 2000 only have
arguments for pivot table and one argument for a field name. Is it possible
in Excel 2000 to have the function look for more than 1 pivot table field?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html