Posted to microsoft.public.excel.misc
|
|
Help to create this
It's simply great.
Are you a genius?
Thank you very much.
Marco
"Don Guillett" wrote:
This should do it for you.
Sub lineemup()
Dim i, lc1, lc2 As Long
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Cells.WrapText = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Cells(i - 1, 1) = Cells(i, 1) Then
lc1 = Cells(i - 1, Columns.Count).End(xlToLeft).Column + 1
lc2 = Cells(i, Columns.Count).End(xlToLeft).Column
Cells(i, 2).Resize(1, lc2).Copy Cells(i - 1, lc1)
Rows(i).Delete
End If
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Marco" wrote in message
...
Hi. I need help to create this:
I've got my actual view like this: (Rows)
ID DInicio DFim
3000 38279 38340
3000 38353 38561
3000 38578 38927
and I need to make it look like this: (one reocord, columns)
ID DInicio DFim DInicio DFim DInicio DFim
3000 38279 38340 38353 38561 38578 38927
Please help me out here.
Regards in advance.
Marco
|