SJT,

No. I think to do what you want automatically will require a macro. But you
can manually select AJ7:AJ12 and AP7:AP12 (drag the first range, then
holding Ctrl drag the second), then do a paste.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"SJT" wrote in message
...
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.