How to Change the Range of a Macro

[jarreau82]

Good Afternoon All,

I've got a set of resource usage graphs over time built in Excel. Every week, I go in and update actuals through the current period, and also update my forecast for all future periods. So for example: week 5 - weekly actuals are in columns A through E, and weekly forecast hours are in columns F through J; week 6 - Weekly actuals are in columns A through F, and weekly forecast hours are in columns G through J. Basically the actuals range grows, and the forecast range shrinks every update.

Is there a way to do this with a Macro? My VBA skills are very basic. I can record and run a Macro, and edit in VBA.

Thanks in advance!

 

[Trevor G]

Can you change the tables to Data Table then use them as the source for the Charts and the Charts will be dynamic and change as soon as you change the data.