Split a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

I have a spreadsheet with a number of columns (6) one of the columns is
composed of 6 rows. The other 5 have the 6 rows merge into one cell. I have
tried to show below

Merge 1 merge
Merge 2 merge
Merge 3 Merge
Merge 4 Merge

I want to be able to add 5 (or more) new rows to the non merge column but
automatically merge the others.

I tried to use a macro but when you run it add a row for all.

Does anyone know a trick for this?

Any help greatly appreciated

Rexmann (using 2003)
 
If I follow you correctly, try adding cells and shifting down instead of
inserting rows.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
You're very welcome, glade that you got it sorted out.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top