Hi there,
I have columns of data in sheet1 that I am tranposing to rows sheet2, but when I insert columns in sheet1 although sheet 2 updates the old corresponding row of associated data are now mislaligned.

Below is a basic example of the problem;

Before;
Sheet1 Sheet2
aa bb cc aa "text for aa"
bb "text for bb"
cc "text for cc"

After column addedd with xx data;
Sheet 1 Sheet 2
aa bb xx cc aa "text for aa"
bb "text for bb"
xx "text for cc"
cc

And what I want to happen automatically when I insert "xx" into a new column in Sheet1 is;
Sheet 1 Sheet 2
aa bb xx cc aa "text for aa"
bb "text for bb"
xx
cc "text for bb"

Is this possible?

Many thanks
Dave