Thread: Macro to Change Source Data Columns

Hi All,

Hope someone can help me with this.

Using Excel 2003.

I have a worksheet with 30+ charts covering the last 12 month period, each month I have to delete column A and insert a new column L, but I then have to change the Source Data on each chart to reflect the amended columns which takes a long time.

Can this be done by macro and if so would it be possible to advise how to do so.

Thanks very much.

Why do you need to delete and insert columns?

Could you not copy+paste B:L over to A:K then paste new data in L.

Originally Posted by Andy Pope

Why do you need to delete and insert columns?

Could you not copy+paste B:L over to A:K then paste new data in L.

Thanks very much Andy, I placed it into a macro and it worked a treat.