Consolidating spreadsheets in excel 2016

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.

The following macro steps through all the worksheets and combines the data to a new worksheet it adds at the beginning of the workbook.

Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).

Comments are the opinions of their authors; they do not represent the views or opinions of Money Under 30.

Comments