Not just simple copy and paste

[Keebler]

so i have a collection of every evolving sets of data.
sometimes the data has merged cells, or merged cells with wrapped text, or just plain text.
what i need to learn how to do is to make a live (if possible) copy of the data to another part of the same sheet.

the setup
i have a range (a4:l48)
i need to have an exact copy (including formatting, merged cells, etc) made in range (m4:x48)
VBA is preferred but not required
my attempts to perform this so far have been using formulas and indexes -- it is cumbersome and does not copy formatting. only the text.
any help getting pointed in the correct direction would be greatly appreciated thank you

 

[rowebca]

im sorry, the squares a little bit more than half way down
if they can not be copied, thats fine.
nevermind, im being picky... thank you- what you have done is perfect.. im sorry
please disregard.. im sorry- i do not know how to remove my complaint here

You don't have to apologize, I am here to help.

GB

 

[Keebler]

again, thank you very much for your time, please accept my apologies.
it did not copy the stupid squares, its okay. ill just copy them manually, truth is they really do not matter...
thank you, and i again apologize.

 

[rowebca]

again, thank you very much for your time, please accept my apologies.
it did not copy the stupid squares, its okay. ill just copy them manually, truth is they really do not matter...
thank you, and i again apologize.

You should try the last code that will copy the images too. You didn't tell me in the beginning that you have images there. Again, don't apologize, I love to help people with any chance I have.

Regards,
GB

 

[MARK858]

@Keebler Try just adding the line

ActiveSheet.Paste

Above the End Sub line or after the lines posted by rowebca if in the middle of a bigger sub