| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine workbooks into one master workbook.
Help is greatly appreciated!!!
I do understand that Excel VBa can greatly reduced my spreadsheet workloads, but I am not adept at using this application. Right now my problem is, I have 3 different workbooks containing more than 20 worksheets, what I need is to copy a certain range of data on all worksheets to a single master worksheets, and from there I could do the data analysis. Another issue is that this workbooks come from different person, though they have the same formats, I'm not sure if they all use the same ranges. Can this be process using VBA? If so, please guide me in creating one. Thanks for the help! EKB |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine workbooks into one master workbook.
Hi EKB
Start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "EKB" wrote in message ups.com... Help is greatly appreciated!!! I do understand that Excel VBa can greatly reduced my spreadsheet workloads, but I am not adept at using this application. Right now my problem is, I have 3 different workbooks containing more than 20 worksheets, what I need is to copy a certain range of data on all worksheets to a single master worksheets, and from there I could do the data analysis. Another issue is that this workbooks come from different person, though they have the same formats, I'm not sure if they all use the same ranges. Can this be process using VBA? If so, please guide me in creating one. Thanks for the help! EKB |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine workbooks into one master workbook.
Hi Ron,
I'm just starting to browse the link you have given. Thanks. EKB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating a master workbook with 80 workbooks | Excel Discussion (Misc queries) | |||
| Merge Shared Workbooks into a Master Workbook | Excel Discussion (Misc queries) | |||
| How to update a master workbook from 3 different slave workbooks? | Excel Discussion (Misc queries) | |||
| Update master workbook from individual workbooks | Excel Discussion (Misc queries) | |||
| Importing Workbooks into a Master Workbook | Excel Worksheet Functions | |||
Linear Mode
