I'd start by recording a macro when I did it manually.

Post back with any questions when/if you get stuck.



wrote:

I want to write a macro that takes certain data from one
excel spreadsheet file on the hard drive and drops it into
another. How do you do this? I am using excel 2002.

--

Dave Peterson