Consolidating two excel files Dancing webcam sites
Open(every Obj) '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"). Alternatively, you can use Power Query in Excel 2013, renamed Get and Transform in Excel 2016, but those features require far more experience with database queries than the average Excel user has accumulated at this point.Fortunately, Microsoft Query is an alternative that is available in all versions of Excel that can guide you through the process.
Files For Each every Obj In files Obj Set book List = Workbooks.
Just close the source wookbook and do it again with the next one, until you've collected all the worksheets you care about into one large wookbook. Would you like to answer one of these unanswered questions instead?