Combining Excel Workbooks and worksheets

V

Vp

I have approx 100 excel files which contain 1 - 10 sheets each. I would
like to combine the worksheets from the individual files into one master
workbook and then combine the data from each worksheet into one master
worksheet. Each worksheet can have slightly different no of rows and
columns.

I have searched the various excel newsgroups and have not found anything
that seems to meet my needs.

Can anyone help me with some VBA programming that can accomplish this task.

Thanks in advance for your help

Victor P

PS - I am reasonably proficient with excel but I have no VBA experience
 
V

Vp

Thanks for the info - i checked out the link you listed and it appears that
the macro will only pick up the first sheet from each workbook. I need to
pick up all of the sheets from multiple workbooks
 
R

Ron de Bruin

You can change the code to do that VP
Try it and post back if you got problems
 

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

Visio to Excel 0
Embed the same Excel multiple times 0
Combining three files when middle file has sections with endnotes 2
Combining Multilple Worksheets Into One 6
VBA to do a mailmerge from a Specific Excel worksheet 0
Combine multiple worksheets in one Workbook into one big worksheet 6
Changing name of worksheet based on data in cell of another worksheet 14
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0

Top