| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transfer rows between workbooks automatically
I have about 100 excel spreadsheets with one line of information in the top
row on the first sheet in a folder. I need to copy the one line from each workbook and put them in another workbook all on the same sheet in different rows. Is there anyway to automate this? Thanks for any help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
transfer rows between workbooks automatically
Hi BillyRogers
Look here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BillyRogers" wrote in message ... I have about 100 excel spreadsheets with one line of information in the top row on the first sheet in a folder. I need to copy the one line from each workbook and put them in another workbook all on the same sheet in different rows. Is there anyway to automate this? Thanks for any help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
transfer rows between workbooks automatically
thanks for the help
"Ron de Bruin" wrote: Hi BillyRogers Look here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BillyRogers" wrote in message ... I have about 100 excel spreadsheets with one line of information in the top row on the first sheet in a folder. I need to copy the one line from each workbook and put them in another workbook all on the same sheet in different rows. Is there anyway to automate this? Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected workbooks blocking transfer of data | Excel Discussion (Misc queries) | |||
| workbooks transfer from 2000 to 2007 | Excel Worksheet Functions | |||
| Query: Automatically transfer complete rows? | Excel Worksheet Functions | |||
| How can I transfer formulas between 2 Excel workbooks? | Excel Worksheet Functions | |||
| (A repost) Automatic transfer of data between 2 workbooks | Excel Programming | |||
Linear Mode
