Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting rows into worksheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting rows into worksheets
Thanks Ron I appreciate the help.
"Ron de Bruin" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Rows into multiple worksheets | Excel Discussion (Misc queries) | |||
inserting rows on multiple worksheets | Excel Worksheet Functions | |||
inserting rows on multiple worksheets | Excel Worksheet Functions | |||
Inserting/deleting rows between worksheets | Excel Worksheet Functions | |||
Inserting rows into worksheets that are protected | Excel Worksheet Functions |