Record a macro when you open book2, do the copy|paste and close book2 (and
save).

Continue recording when you open book3 and copy|paste and close book3 (and
save).

And you'll see the code.

Max Bialystock wrote:

How can I copy the contents of A1 in C:\users\book1.xls to C9 in
D:\users\book2.xls and to C9 in D:\users\book3.xls.

Let's assume that both workbooks on drive D are closed.

--

Dave Peterson