Copy paste non merged to merged cells

J

jamalhakem

Hi
I have 2 sheets, in sheet 1 I have
A B
1 Name Number
2 Name Number
3 Name Number
Etc….
In sheet 2 I have:
A1, A2, and A3 merged, B1, B2, and B3 merged, etc…
Any way to copy and paste the data in sheet1 to sheet2 in a way that
in merged A1, A2 and A3 in sheet2 have the same data in A1 in sheet1,
in a way to copy and paste many columns, up to 900 columns, in an easy
way, not copying and pasting every cell.
Thanks in advance
Jam
 
P

Pete_UK

In what way does this differ from the post I've just responded to?
Please don't multi-post.

Pete
 

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 non merged to merged cells 2
Copy non merged to merged cells again 1
Merged cells 1
Auto Filter and Merged Cells 2
Query content of merged cells 3
Linking Merged Cells 2
(2003) Pasting into merged cells 3
Locate merged cells to sort on 3 columns 2

Top