PDA

View Full Version : Combining data from multiple workbooks (specific sheet) into a specific workbook



VenomWRX
11-10-2011, 10:34 AM
Greetings everyone. I had done a search with regards to combining data from various workbook into a specific workbook/excel file. Nonetheless, could not find the answer. Basically im a newbie and learning along the way in terms of VBA. Ok here we go and apologise as its quite lengthy. I have 3 excel files , namely SCORE 1, SCORE 2, and SCORE 3. (they might be more similar filenames in future). In every workbook, there are 2 sheets, namely sheet 1 and SCORE. I only want to copy the data from the sheet name SCORE. The destination file would be another separate Excel File named SCORESUMMARY. In the scoresummary, there are same no. Of sheets too, namely sheet1 and SCORE and I only want the data copied from the various excel sheets to be pasted onto the sheet named SCORE. In terms of heading, its the same for all the 3 excel files, I have 2 headers, in cell B1 (named Number) and in cell C1 (named SCORE). The data is in B1 downwards and C1 downwards. In my consolidated/destination excel file, named SCORESUMMARY, the headers are the same too. Seek your help in having a macro where upon running of SCORESUMMARY, it will extract all the data from the 3 other excel files/workbook and display it in the sheet named SCORE. I have attached a sample format. Thank you.

GTO
11-10-2011, 11:14 AM
Greetings,

Welcome to vbaexpress, as I see you recently joined and this is your first post. Please read Here (http://www.excelguru.ca/node/7) reference cross-posting.

Cross-posted: http://www.mrexcel.com/forum/showthread.php?t=591402