Can cells be split ?

S

Steve

I have employees listed in column A
One employee in each row.
Can I split cells in B to create 3 cells in B1, etc.

Currently this:
A B
Smith B1 -one cell
Jones B2 - one cell

Want this:
Smith one cell
two cell
three cell
Jones one cell
two cell
three cell
Ok if employees end up merged so that Smith is cells A1:A3, Jones is in
cells A4:A6, etc.

Thanks,

Steve
 
O

Otto Moehrbach

Steve
This little macro might help. I assumed your names are in Column A starting
in A2. This macro will insert 2 blank rows below every name. Is this what
you want? HTH Otto
Sub Insert2Rows()
Dim rColA As Range
Dim c As Long
Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
For c = rColA.Count To 1 Step -1
rColA(c).Offset(1).EntireRow.Resize(2).Insert
Next c
End Sub
 
S

Steve

Perfect. Thanks,

Now, can a macro be written to merge the initial rows with the 2 blank rows
below it, but only for columns A-K, keeping L & M with the added rows/cells ?
Like merging A5:K7, then A8:K10, etc. ?

Thanks,

Steve
 
O

Otto Moehrbach

Steve
I've been out of pocket for the past week. If you wish send me your
file, or a sample of it, clearly showing before and after. Include a copy
of this post and your previous posts in this thread. My email is
(e-mail address removed). Remove the "extra" from this address. Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top