|
|
我们单位每天都要生成一张EXCEL表，表的内容就是一行一行的，每一行有一个固定编号，一行一个记录，但每张表的记录总数不一定相同（行数不同）
这样的表每天都要生成一张，所有格式都是相同的，只是表格里的内容不同。每张表的名字就是当天的日期，比如2014.07.01
现在想用一个简单的办法，把这一个月的表的数据（从2014.07.01到2014.07.03共3张表）合并到同一张表里，保持固定的编号不变，也就是说，合成的这张表，拥有表01-03所有的数据。
我该如何实现最方便呢？（因为我实际要合并的是N年的表，可能有上千张表，所以一个个复制粘贴很累，而且容易出错）
谢谢各位大神！
我把文件整理了一下，做个范本吧，压缩包
Excel.rar
(29.11 KB, 下载次数: 9)
里一共三个文件，名称分别是：
MM deal 2014.07.01
MM deal 2014.07.02
MM deal 2014.07.03
和
MM deal 汇总表（把前三张表的数据全都汇总到这张表里来，按序号排列下来就行）
每个表里的数据（黄色部分）都是从第8行开始的，也就是有序号的那几行（从1到7）
MM deal 2014.07.01
| Deal No. | Counterparty | Phone(P) E-mail(E) Reuters(R) CFETS(C ) | Broker | Borrow (B) Lend (L) | Value | Maturity | Curr | Principal Amt | Rate | Interest | P+I | Tenor | Traded by J/F | Time | Funding Purpose or Remarks | 1 | AAA | | | B | 1-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,900.00 | 30,002,900.00 | 29 | J | 0953 | | 2 | AAA | | | B | 1-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,611.11 | 20,001,611.11 | 29 | J | 0953 | |
MM deal 2014.07.02 | Deal No. | Counterparty | Phone(P) E-mail(E) Reuters(R) CFETS(C ) | Broker | Borrow (B) Lend (L) | Value | Maturity | Curr | Principal Amt | Rate | Interest | P+I | Tenor | Traded by J/F | Time | Funding Purpose or Remarks | 3 | BBB | | | B | 2-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,800.00 | 30,002,800.00 | 28 | J | 0953 | | 4 | BBB | | | B | 2-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,555.56 | 20,001,555.56 | 28 | J | 0953 | |
MM deal 2014.07.03
| Deal No. | Counterparty | Phone(P) E-mail(E) Reuters(R) CFETS(C ) | Broker | Borrow (B) Lend (L) | Value | Maturity | Curr | Principal Amt | Rate | Interest | P+I | Tenor | Traded by J/F | Time | Funding Purpose or Remarks | 5 | CCC | | | B | 3-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,700.00 | 30,002,700.00 | 27 | J | 0953 | | 6 | CCC | | | B | 3-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,500.00 | 20,001,500.00 | 27 | J | 0953 | | 7 | CCC | | | B | 3-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,500.00 | 20,001,500.00 | 27 | J | 0953 | |
以上三个表的数据都汇总到最后那张空表里去，就形成这样的一张表：
| Deal No. | Counterparty | Phone(P) E-mail(E) Reuters(R) CFETS(C ) | Broker | Borrow (B) Lend (L) | Value | Maturity | Curr | Principal Amt | Rate | Interest | P+I | Tenor | Traded by J/F | Time | Funding Purpose or Remarks | 1 | AAA |
|
| B | 1-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,900.00 | 30,002,900.00 | 29 | J | 0953 |
| 2
| AAA |
|
| B | 1-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,611.11 | 20,001,611.11 | 29 | J | 0953 |
| 3
| BBB |
|
| B | 2-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,800.00 | 30,002,800.00 | 28 | J | 0953 |
| 4
| BBB |
|
| B | 2-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,555.56 | 20,001,555.56 | 28 | J | 0953 |
| 5
| CCC |
|
| B | 3-Jul-14 | 30-Jul-14 | USD | 30,000,000.00 | 0.120000% | 2,700.00 | 30,002,700.00 | 27 | J | 0953 |
| 6
| CCC |
|
| B | 3-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,500.00 | 20,001,500.00 | 27 | J | 0953 |
| 7
| CCC |
|
| B | 3-Jul-14 | 30-Jul-14 | USD | 20,000,000.00 | 0.100000% | 1,500.00 | 20,001,500.00 | 27 | J | 0953 |
|
|
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2014-7-29 16:28
楼主