PDA

View Full Version : Sleeper: Cell Reference Problem in vertical layout



sonashish
02-03-2005, 11:21 PM
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
02-05-2005, 08:22 PM
Are you trying to do something like This (http://www.vbaexpress.com/kb/getarticle.php?kb_id=144)?