Copying all offset cells

I want to be able to have a range selected and copy the cells offset it it at (0,-2),(0, -4) and (0,-7) all at the same the to reduce the macro time. Does any one know of a way to do this?

Maybe:

Please Login or Register  to view this content.