Hi Tobie
Start here
http://www.rondebruin.nl/copy1.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Tobie" <(E-Mail Removed)> wrote in message news:2C3CF0F2-A979-4DF5-A80F-(E-Mail Removed)...
> Im trying to get a macro working to copy one row in Worksheet1 and paste it
> to the first empy row on Worksheet2.
>
> Anyone got a good way of doing this?
>
> (you will make a list with the "items" from one sheet and maybee insert
> three of one row called S-72 and then you want two of S-12 underneith it,
> then a spacer, and so on)