I'm tring to figure out how to copy and paste multiple cells into multiple
merged cells. For example:
A1 A2 A3 B6 B7 B8
1 2 3

copy A1 A2 A3 (nonmerged cells) into B6 B7 B8 (merged and centered cells)
if i do this one at a time it works fine, but if i try to do them all at
once it takes the merged cells (B6 B7 B8) and removes the merged and center
format. Is there a way to do this or do i need to just keep doing it one by
one, which is very time consumming, as i have alot of these to do?