Combining Excel Workbooks and worksheets

  • 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
 
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
 
Back
Top