Folks...

You gotta help me. I want to paste a serious of questions from column B on
sheet 1 into column B on sheet 2. However the cells on sheet 2 are merged
between B and G which means that when I paste into sheet 2 I get the contents
in every horizontal cell B C D E F & G. I have 2000 questions to copy across
30 sheets. All I want to do is copy and paste. Is there a way to make sure
when I paste that the question fills the merged cell rather thah demerging it
and laying down 6 repeats of the question that I have to back into and
demerge?

You'd think life would be simpler!

Thanks

Gordon...

before doing the copy/paste you should create an equivalent merge structure
in sheet2 to the one in sheet1.

Run down the appropriate columns in sheet1, and if the cells are merged in
any row, merge the same cells in sheet2.

Once this has been accomplished the copy/paste will be much easier.
--
Gary''s Student
gsnu200709


"Gordon" wrote:

Folks...

You gotta help me. I want to paste a serious of questions from column B on
sheet 1 into column B on sheet 2. However the cells on sheet 2 are merged
between B and G which means that when I paste into sheet 2 I get the contents
in every horizontal cell B C D E F & G. I have 2000 questions to copy across
30 sheets. All I want to do is copy and paste. Is there a way to make sure
when I paste that the question fills the merged cell rather thah demerging it
and laying down 6 repeats of the question that I have to back into and
demerge?

You'd think life would be simpler!

Thanks

Gordon...

What do the formulas in B & C of Sheet2 look like? Sample values?

Merjet

No formulas, just text.

"merjet" wrote:

What do the formulas in B & C of Sheet2 look like? Sample values?

Merjet

Hi...

I think you've missed the point here. There are 2000 questions across 30
sheets your solution will take forever...

"Gary''s Student" wrote:

before doing the copy/paste you should create an equivalent merge structure
in sheet2 to the one in sheet1.

Run down the appropriate columns in sheet1, and if the cells are merged in
any row, merge the same cells in sheet2.

Once this has been accomplished the copy/paste will be much easier.
--
Gary''s Student
gsnu200709


"Gordon" wrote:

Folks...

You gotta help me. I want to paste a serious of questions from column B on
sheet 1 into column B on sheet 2. However the cells on sheet 2 are merged
between B and G which means that when I paste into sheet 2 I get the contents
in every horizontal cell B C D E F & G. I have 2000 questions to copy across
30 sheets. All I want to do is copy and paste. Is there a way to make sure
when I paste that the question fills the merged cell rather thah demerging it
and laying down 6 repeats of the question that I have to back into and
demerge?

You'd think life would be simpler!

Thanks

Gordon...

If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet

Thats my point...

I highlight column B in sheet 1 and then go to column B in sheet 2 and
paste. because column B is merged with CDEF&G the question is pasted into
thise cilumns too, even though the cell was merged. Pasting demerges and
places the question in 6 cells horizontally!

"merjet" wrote:

If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet

How about a macro that would go down column B in the source sheet looking for
mergers? It would create equivalent mergers in the destination sheet before
doing the paste?


Check back tomorrow.


--
Gary's Student
gsnu200709


"Gordon" wrote:

Thats my point...

I highlight column B in sheet 1 and then go to column B in sheet 2 and
paste. because column B is merged with CDEF&G the question is pasted into
thise cilumns too, even though the cell was merged. Pasting demerges and
places the question in 6 cells horizontally!

"merjet" wrote:

If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet

Gordon

You'd think life would be simpler!

It can be.

Get rid of the merged cells which cause no end of problems with copying,
pasting, sorting, filtering and a bunch of others I can't think of right now.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 08:33:36 -0800, Gordon
wrote:

Hi...

I think you've missed the point here. There are 2000 questions across 30
sheets your solution will take forever...

"Gary''s Student" wrote:

before doing the copy/paste you should create an equivalent merge structure
in sheet2 to the one in sheet1.

Run down the appropriate columns in sheet1, and if the cells are merged in
any row, merge the same cells in sheet2.

Once this has been accomplished the copy/paste will be much easier.
--
Gary''s Student
gsnu200709


"Gordon" wrote:

Folks...

You gotta help me. I want to paste a serious of questions from column B on
sheet 1 into column B on sheet 2. However the cells on sheet 2 are merged
between B and G which means that when I paste into sheet 2 I get the contents
in every horizontal cell B C D E F & G. I have 2000 questions to copy across
30 sheets. All I want to do is copy and paste. Is there a way to make sure
when I paste that the question fills the merged cell rather thah demerging it
and laying down 6 repeats of the question that I have to back into and
demerge?

You'd think life would be simpler!

Thanks

Gordon...