I have selected the range of AD7:AD12 and would like to copy it and then
paste it over a range where I would like it to paste only in every sixth
column. So for example I would select the pasting range to be AE7:AP12 and
would only want the contents to paste in columns AJ and AP. Is there a paste
special function or some other function that would allow me to accomplish
this?

Thank you in advance for your assistance.