Hi,
I have a number of graphs that look at fields within Excel
ie:
=Adj2005!$C$154:$L$154
Each month I have to update the last 3 digits to reference the latest data
ie:
=Adj2005!$C$154:$L$155
This is time consuming, so I thought I could create a field add a name and and the 3 digits and update the info by referencing the one field.
ie:
Field Name: Period
So it might look something like this:
=Adj2005!$C$154:$L$"&Period&"
However I can't seem to be able to get the above format correct in the values field, can someone advise please.
Thanks
Darrell....
I have a number of graphs that look at fields within Excel
ie:
=Adj2005!$C$154:$L$154
Each month I have to update the last 3 digits to reference the latest data
ie:
=Adj2005!$C$154:$L$155
This is time consuming, so I thought I could create a field add a name and and the 3 digits and update the info by referencing the one field.
ie:
Field Name: Period
So it might look something like this:
=Adj2005!$C$154:$L$"&Period&"
However I can't seem to be able to get the above format correct in the values field, can someone advise please.
Thanks
Darrell....