number layout

  • Thread starter Thread starter matmich
  • Start date Start date
M

matmich

I have a column of item numbers and what I need to do is take and assig
only 3 numbers to a column then start w/ next col.

EX

I have
100
101
103
104
105
256
258
369
398
405
506
360

I need
100 104 258 405
101 105 369 360
103 256 398 36
 
Hi
try the following on a second sheet in cell A1 (assumption: your source
data is on sheet 1 in column A)
=OFFSET('sheet1'!$A$1,ROW()-1 + (COLUMN()-1)*3,0)
and copy down / to the right
 
Here's a macro to do it

Sub MoveThem()
Dim i As Long, j As Long

j = 1
For i = 4 To Cells(Rows.Count, "A").End(xlUp).Row Step 3
j = j + 1
With Cells(i, "A").Resize(3, 1)
.Copy Destination:=Cells(1, j)
.ClearContents
End With
Next i

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
frank, I tried your formula but no luck, am I supposed to enter
something in the () for the row and column?? And if so what?
 
Hi
no you don't have to enter anything in this brackets. What did not work
for you (wrong results, formula error)?
 
Back
Top