Devi usare una macro:

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