The first sheet name in the offset formula is spelled incorrectly --
finanancial
If that's not the problem, what error do you get?
Is there a heading in each cell in the first row of the source data?
Daniel wrote:
I made a pivot table with dynamic range and below is my offset function
the name is defined "finacialoffset"
the worksheet name is " financial"
the number of column is 6
=OFFSET(finanancial!$A$1,0,0,COUNTA(financial!$A:$ A),6)
BUT I have error as above! when I put this name in wizard
Any comment are welcome
Thanks
Daniel
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html