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.
<tbody>
</tbody>
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.
Jeff | Mark | Phil | |||
Height | 194 | 175 | 166 | ||
Weight | 81 | 76 | 60 | ||
Jeff | Jim | Mark | Phil | ||
Height | 194 | 175 | 166 | ||
Weight | 81 | 76 | 60 | ||
Jess | Jim | Mark | Phil | ||
Height | 194 | 175 | 166 | ||
Weight | 81 | 76 | 60 | ||
<tbody>
</tbody>
Any help would be much appreciated
Thanks