View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kenny Kenny is offline
external usenet poster
 
Posts: 27
Default Copy data from one workbook to another of same name

Greetings All,

Here is my problem: I need to copy the first 50 rows of a
workbook and paste it into another of a similar name.
More specifically, I have a folder of files that each need
to have their first 50 rows copied and pasted into files
that reside in another folder. Somehow I need to ensure
that File A in Folder One, pastes those 50 rows into File
A of Folder Two..... and so on through File Z.

Am I drunk, and/or can this be done?!!