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 ?

 

[Harvey]

I think you should use a macro to change the references, change "A" in "1", "B" in "2" and so forth.

 

[sonashish]

Harvey

I know this, as I am newbie in IT. IS there any example on this or can you help me in this matter if it is not against your ethics?

Ashi

 

[Harvey]

Those references do they all have the same build? Can you post some of them?
I think there has to be some built in tool for this.