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

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

Combine workbooks into one master workbook.
 

Hi Ron,

I'm just starting to browse the link you have given.
Thanks.

EKB