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


Replace @mailinator.com with @tiscali.co.uk


"rexmann" wrote in message
...
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)

Hi Sandy

Thanks just what I needed

Cheers Rexmann

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"rexmann" wrote in message
...
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)

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


Replace @mailinator.com with @tiscali.co.uk


"rexmann" wrote in message
...
Hi Sandy

Thanks just what I needed

Cheers Rexmann

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"rexmann" wrote in message
...
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)