View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ckotsis
 
Posts: n/a
Default Manual Transpose


Euxaristo poli na eisai kala. Episis egrapsa kai ton parakato kodika

Dim x, k, j As Integer

Sub Button3_Click()
k = 1
x = 1
j = 2
Do
For x = 1 To 10
Worksheets("Sheet3").Cells(j, x).Value =
Worksheets("Sheet2").Cells(k, 1).Value
k = k + 1
Next x
j = j + 1
Loop While IsEmpty(Worksheets("Sheet2").Cells(k - 10, 1).Value) <
True
End Sub


--
ckotsis
------------------------------------------------------------------------
ckotsis's Profile: http://www.excelforum.com/member.php...o&userid=31759
View this thread: http://www.excelforum.com/showthread...hreadid=514834