View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default inserting rows into worksheets

Hi Cam

You can use this macro to do what you want
http://www.rondebruin.nl/copy4.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CAM" wrote in message ...
Hello,

I have a folder called "C\Processing\" contianing 25 different workbooks
with only one sheet. What I want to do is copy information from 5 rows
starting from cell "A1" based on a sheet from a workbook called "Master" (it
could be in the same folder or different) and inserting the 5 rows of
information into each of the sheets of the 25 workbook. The 25 workbooks
already have information starting from "A1", which has headers. I just
want to insert the copy above the headers on each sheet of the 25
workbooks. Is this possible. Any tips will be appreciate. Thank you in
advance.

Cheers