Combining multiple Workbooks into single file

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
 

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
Possible to Combine reports to's to a single box? 0
Combining three files when middle file has sections with endnotes 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Embed the same Excel multiple times 0
Update several ppt documents from a single excel file 0
combine multiple spreadsheets into one workbook 1
Use a master workbook to carry over changes to multiple workbooks 1

Top