I have a 30 charts to update every month I found how to expande the range with the below defined names.. But I can not get it to work with multiple charts using the same Y values.
=OFFSET('Basic Range'!YValues,0,-1)
=OFFSET('Basic Range'!$B$5,0,0,COUNTA('Basic Range'!$B:$B)-1,1)
Multiple people enter data onto the sheets and I am trying to eliminate having 30 rows of Jan - December.
Any and all help would be appreciated greatly, John
=OFFSET('Basic Range'!YValues,0,-1)
=OFFSET('Basic Range'!$B$5,0,0,COUNTA('Basic Range'!$B:$B)-1,1)
Multiple people enter data onto the sheets and I am trying to eliminate having 30 rows of Jan - December.
Any and all help would be appreciated greatly, John