[已解决]请高人指教如何把每张工作表数据汇总到一个表中

欢乐英雄

众位高人，我想求教一个问题，在一个工作簿，里面有1-12月份共12个月的全体员工养老保险工作表，其中每个月工作表人员顺序都不一样，而且有频繁的调入调出变化，我需要做一个汇总表，统计全年每名员工每个月共扣了多少钱，有什么简便的方法吗？

最佳答案

月排行榜 / 总排行榜

云影

2013-5-28 21:44

1. SELECT *,"1月" FROM[(1)$A:B] UNION ALL SELECT *,"2月" FROM[(2)$A:B] UNION ALL SELECT *,"3月" FROM[(3)$A:B] UNION ALL SELECT *,"4月" FROM[(4)$A:B] UNION ALL SELECT *,"5月" FROM[(5)$A:B] UNION ALL SELECT *,"6月" FROM[(6)$A:B] UNION ALL SELECT *,"7月" FROM[(7)$A:B] UNION ALL SELECT *,"8月" FROM[(8)$A:B] UNION ALL SELECT *,"9月" FROM[(9)$A:B] UNION ALL SELECT *,"10月" FROM[(10)$A:B] UNION ALL SELECT *,"11月" FROM[(11)$A:B] UNION ALL SELECT *,"12月" FROM[(12)$A:B]

复制代码

跳转到最佳答案楼层

zxm108613

已做好，请采纳。

zxm108613

先做个多维数据透视，再用数据清单做一个数据透视表就好了。

云影

1. SELECT *,"1月" FROM[(1)$A:B] UNION ALL SELECT *,"2月" FROM[(2)$A:B] UNION ALL SELECT *,"3月" FROM[(3)$A:B] UNION ALL SELECT *,"4月" FROM[(4)$A:B] UNION ALL SELECT *,"5月" FROM[(5)$A:B] UNION ALL SELECT *,"6月" FROM[(6)$A:B] UNION ALL SELECT *,"7月" FROM[(7)$A:B] UNION ALL SELECT *,"8月" FROM[(8)$A:B] UNION ALL SELECT *,"9月" FROM[(9)$A:B] UNION ALL SELECT *,"10月" FROM[(10)$A:B] UNION ALL SELECT *,"11月" FROM[(11)$A:B] UNION ALL SELECT *,"12月" FROM[(12)$A:B]

复制代码

欢乐英雄

收到，学习

xzsychenwei

本来感觉挺麻烦的，下载后看了下，牛！