| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can i import worksheets from multiple workbooks
Hi,
I have a bunch of workbooks that all used the same template and were filled out for each week of the year. They all have a "totals" sheet the collects all the important data within. What i want to do is create a macro that imports that totals page, or a section of it from a bunch of these different workbooks, say all the ones in january or maybe the entire years worth so i can do some more analysis. my VBA skills are terrible but i am learning slowly. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can i import worksheets from multiple workbooks
Hi David
You can start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "davidp23" wrote in message ... Hi, I have a bunch of workbooks that all used the same template and were filled out for each week of the year. They all have a "totals" sheet the collects all the important data within. What i want to do is create a macro that imports that totals page, or a section of it from a bunch of these different workbooks, say all the ones in january or maybe the entire years worth so i can do some more analysis. my VBA skills are terrible but i am learning slowly. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
