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 3
Copy non merged to merged cells again 2
Page numbering with Merged Document and IF statements 1
Merged cells 1
Copy addition formula of non-consecutive horizontal cells 2
Set up and printing a 4-up mail merged postcard 0
Pivot Table and Merged Cells Help 1
Need Help with a VBA subroutine 0

Top