Have you ever had several spreadsheets that have different content but they have have same characteristics (Rows different but columns are same)
This is an excel macro that will import all spreadsheets in a given directory into s single spreadsheet with all the data in one workbook.
To execute the code in excel (from a bland spreadsheet) from the Excel Ribbon: View > Macros > Provide Macro Name > Create
Sub simpleXlsMerger() Dim bookList As Workbook Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As Object Application.ScreenUpdating = False Set mergeObj = CreateObject("Scripting.FileSystemObject") 'change folder path of excel files here Set dirObj = mergeObj.Getfolder("c:\folder\path") Set filesObj = dirObj.Files For Each everyObj In filesObj Set bookList = Workbooks.Open(everyObj) 'change "A2" with cell reference of start point for every files here 'for example "B3:IV" to merge all files start from columns B and rows 3 'If you're files using more than IV column, change it to the latest column 'Also change "A" column on "A65536" to the same column as start point Range("A2:IV" & Range("A65536").End(xlUp).Row).Copy ThisWorkbook.Worksheets(1).Activate 'Do not change the following column. It's not the same column as above Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial Application.CutCopyMode = False bookList.Close Next End Sub
Then Run the Macro and all the excel files located in the c:\folder\path will be merged into one worksheet