Combining multiple Workbooks into single file

  • Thread starter Thread starter Vp
  • Start date Start date
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
 
Back
Top