Combine workbooks into one master workbook.

E

EKB

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to reference a cell from anther workbook without opening it 0
COMBINING WORKBOOKS 1
combine sheets from several workbooks into one 1
split worksheet after empty row into separate workbooks 3
consolidating workbooks into one workbook 2
Pulling data from one workbook to another one using VBA 0
Update #REF! to Active Workbook 1
Combine two workbooks into one 2

Top