Hi!
I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is the third table below.[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jeff[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194
[/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jeff[/TD]
[TD]Jim[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194[/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jess[/TD]
[TD]Jim[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194[/TD]
[TD][/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD][/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help would be much appreciated
Thanks
I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is the third table below.[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jeff[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194
[/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jeff[/TD]
[TD]Jim[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194[/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jess[/TD]
[TD]Jim[/TD]
[TD]Mark[/TD]
[TD]Phil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Height[/TD]
[TD]194[/TD]
[TD][/TD]
[TD]175[/TD]
[TD]166[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Weight[/TD]
[TD]81[/TD]
[TD][/TD]
[TD]76[/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help would be much appreciated

Thanks