Sleeper: Cell Reference Problem in vertical layout

[sonashish]

I have one workbook having 2 worksheet.

In first worksheet having one column called itemno. In this I use to import number in CSV format
In 2nd worksheet having two column i.e. itemno, desc. I have set reference of 1st column of 1st sheet in 1st column of second sheet.

So whenever I import csv in 1st sheet, secondsheet is also populated without any problem.
Now what I did I convert horizontal layout to vertical layout of 2nd grid using Paste Special-Trannpose. Here my problem starts, cell refrenced is gone, nothing has been fixed. Actually All the value of 1st colunm of 1st sheet should be refrenced horizontacally in a 2nd shee 1st row that was earlier first column, but they were not.

Can any one tell me how do I manage this ?

[Jacob Hilderbrand]

Are you trying to do something like This?