工作表中的Mutli工作表数据
问题描述：
DearSir
MS Excell中的
我想要一张表中的多张表数据，我该怎么办？
例子
Sheet1。
姓名年龄
Mano 34
Divya 30
2页
姓名年龄
Lakshan 12
Subha 29
Ritika 05
结果表
SheetName名称年龄
Sheet1。 Mano 34
Sheet1。 Divya 30
Sheet 2 Lakshan 12
Sheet 2 Subha 29
Sheet 2 Ritika 05
DearSir
in MS Excell I want multible sheet data in a sheet , how can i please
Example
Sheet1.
Name Age
Mano 34
Divya 30
Sheet 2
Name Age
Lakshan 12
Subha 29
Ritika 05
Result Sheet
SheetName Name Age
Sheet1. Mano 34
Sheet1. Divya 30
Sheet 2 Lakshan 12
Sheet 2 Subha 29
Sheet 2 Ritika 05
答
Hello Mano，
根据需要创建宏。
请参考这些链接进行合并
http：/ /www.teachexcel.com/free-excel-macros/m-14,combine-workbooks-macro-excel.html [ ^ ]
http://www.excelbee.com/merge-excel-sheets-2010-2007- 2013＃close [ ^ ]
一切顺利：）
Hello Mano,
Create macro accordingly for your need.
Pls refer these links for merging
http://www.teachexcel.com/free-excel-macros/m-14,combine-workbooks-macro-excel.html[^]
http://www.excelbee.com/merge-excel-sheets-2010-2007-2013#close[^]
All the best:)