Copy/Paste error

[Guest]

Hi,

I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from
sheet1 into column C (which is a singular cell) into sheet 2

So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values
into cell C1...I get this error

"This operation requires the merged cells to be identically sized"

is there anyway around this, using a formual or VB code ??

Thanks inadvance

 

[Guest]

Hi,

I am trying to simply copy cells C3:C33 (which are merged cells C,D,E) from
sheet1 into column C (which is a singular cell) into sheet 2

So I select Cells C3:C33 from sheet1, goto sheet 2 and paste special/values
into cell C1...I get this error

"This operation requires the merged cells to be identically sized"

is there anyway around this, using a formual or VB code ??

Thanks inadvance

In sheet 2 cell C1: =Sheet1!C3 And drag down

Then copy the cells and paste them into the same spot as values.

 

[Guest]

Thank you - worked well !

In sheet 2 cell C1: =Sheet1!C3 And drag down

Then copy the cells and paste them into the same spot as values.