You would need code.

See if link helps

http://www.contextures.com/xlcomment...l#CopyAdjacent

VBA Noob