如何将多个excel表格中的数据合并到一同

excel

1、先新建个文件夹，把所有要合并的表格都扔进去，然后在里面新建一个excel表格，打开它 2、右键点击底部的Sheet1（就是工作表标签），选择查看代码（注意！这个功能excel有，WPS好像没有） 3、然后把下面这段代码复制到弹出来的代码框里：

Sub 合并当前目录下所有工作簿的全部工作表()Dim MyPath, MyName, AWbNameDim Wb As workbook, WbN As StringDim G As LongDim Num As LongDim BOX As StrinGAPplication.ScreenUpdating = FalseMyPath = ActiveWorkbook.PathMyName = Dir(MyPath & & *.xls)AWbName = *.nameNum = 0Do While MyName If MyName AWbName ThenSet Wb = *.open(MyPath & & MyName)Num = Num + 1With Workbooks(1).ActiveSheet.Cells(.Range(B65536).End(xlUp).Row + 2, 1) = Left(MyName, Len(MyName) - 4)For G = 1 To Sheets.CountWb.Sheets(G).UsedRange.Copy .Cells(.Range(B65536).End(xlUp).Row + 1, 1)NextWbN = WbN & Chr(13) & *.nameWb.Close FalseEnd WithEnd IfMyName = DirLoopRange(B1).SelectApplication.ScreenUpdating = TrueMsgBox 共合并了 & Num & 个工作薄下的全部工作表。如下： & Chr(13) & WbN, vbInformation, 提示End Sub

4、点一下运行按钮，等一会儿（表格多或者大就会久点），就搞定了！