Hi all
I have a data sheet that is automatically updated monthly for reporting needs.
The data sheet links into a bar graph which shows the trend for the most recently updated month and the previous 11 months (12 months total). It is getting tiresome having to go in and update the Source Data every time the graph nees updating.
The data is always in rows 4-6 inclusive. All that changes is the column by one each month ("June" is column N, "July" is column O etc).
Does anyone have anything that could reduce this to a click of a button?
If i need to add any other detail please ask and i will.
Thanks very much in advance
Marc
I have a data sheet that is automatically updated monthly for reporting needs.
The data sheet links into a bar graph which shows the trend for the most recently updated month and the previous 11 months (12 months total). It is getting tiresome having to go in and update the Source Data every time the graph nees updating.
The data is always in rows 4-6 inclusive. All that changes is the column by one each month ("June" is column N, "July" is column O etc).
Does anyone have anything that could reduce this to a click of a button?
If i need to add any other detail please ask and i will.
Thanks very much in advance
Marc