Try this
http://www.rondebruin.nl/copy1.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message oups.com...
Hey community,

I really need help on this one, Iam a newbie to excel macros and got
stuck with this task. Basically we need a macro that can perfom the
following function;

1)Copy specific cells from workbook1 (e.g A3, D5, C4)
2)Open and existing workbook (workbook2) on the computer
3)Paste cells from workbook1 into the next avialble row in workbook2 in
a certain order. (i.e A3 first, D5 second, and C4last)

I hope the instructions were clear, and appreciate any help i could
get.

Thanks,
Dwight