Copying and Pasting

G

Gordon

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...
 
G

Gary''s Student

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.
 
G

Gordon

Hi...

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

merjet

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
 
G

Gordon

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!
 
G

Gary''s Student

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.
 
G

Gord Dibben

Gordon

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
 

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

Similar Threads

Copy and Paste Word 2010 0
Copy addition formula of non-consecutive horizontal cells 2
Copy columns and paste with blank column between 5
Modify working code to expand the output. 5
Create if partial match then copy and paste data from one cell to another 1
A simple if <> nn then Msgbox "No Match" 5
Macro to Copy/Paste Multiple images 3
Array with many cells from a row but not in order or together 11

Top