Well you either do it manually or automate it using VBA (as Stefi said).

If you don't want to use VBA you have to do it manually ...

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"dakke" wrote in message
...
This copy/paste does not really solve the issue, since it will end up
doing
some more manual work. It will most likely reduce the errors though.

So there is no other solution than to copy/paste?