If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining multiple Workbooks into single file
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 |
#2
|
|||
|
|||
Combining multiple Workbooks into single file
Very Sorry this should have been posted in programming
"Vp" wrote in message news:dwBlb.2041$CP6.1481@okepread04... 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 |
#3
|
|||
|
|||
Combining multiple Workbooks into single file
See answer in Programming Vp
-- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Vp" wrote in message news:dwBlb.2041$CP6.1481@okepread04... 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 |
Thread Tools | |
Display Modes | |
|
|