Consolidating 2 excel sheets
Select ' copy cells selected in the new sheet on last line Selection.
Range("A1") ' work through sheets For J = 2 To Sheets. Activate ' make the sheet active Range(Selection, Selection. Thanks in Advance If only someone could re-post that macro explaining which parts to change for what! If using a later version (Excel 2007 or later), this tip may not work for you. Since I'm using Excel 2016 which has a larger record limit, I changed it to "A1048576" and that did the trick I looked EVERYWHERE for a simple answer to my problem, to simply combine the tables in multiple worksheets (over 130 sheets) within a single workbook into a new sheet within the same workbook. The macro worked best for me, as I didn't want a sum, avg, etc., of my data, just copying the data while keeping my original into. Select ' select all cells in this sheets Selection. Additionally a name may be on one list but not another, therefore it would be added to the master list. @John, Did you notice at the top and bottom of the Blog:....... Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. How would we update the code to include the name of each of the copied sheets near each row of the copied data? Item(2) ' copy cells selected in the new sheet on last line Next End Sub Hi.