Excel linked sheets inserting columns

[taaroa]

Hi,
I have two linked charts in two different sheets. Does anybody knows who I can insert a column in the original chart and get the same inserted column in the linked chart.

Original chart colums *** Linked chart column

A B C D E F *** A B C D E F

After inserting a colum in place of B, I get

Original chart colums *** Linked chart column

A B C D E F G *** A B C D E F no change

I want to have the linked chart automatically modified i.e a new colum insert in B :

Original chart colums *** Linked chart column

A B C D E F G *** A B C D E F G

Thank you

Taaroa

 

[taaroa]

Thanks Bill,

Your solution was amazing!! Congratulations!

taaroa

 

[taaroa]

Hi Bill,

Do you put the second macro in the B file colum H or I.

Thanks.

taaroa

 

[PAB]

Hi taaroa,

What Happened to the Post by Bill ?.
Was it Deleted for Some Reason ?.
If we could see it we Might be Able to Help.

All the Best.
PAB

 

[taaroa]

Hi PAB,

Bill is a virtual person from my imagination. I invented Bill. There had been no response to my post so far. So, I must apologize to you all. That was just a joke.

taaroa