軟體:EXCEL
版本:2010
各位版友大家好:
想要請問如何列印比較快的問題
我現在有一個表單為學生成績
另一個表單為教師授課資料
需提供這些少數額外的成績給原授課教師
現在已經有教師授課班級資料和學生成績
如何快速合併列印
使得授課教師能拿到該授課班級的學生資料
或者
我該再產生什麼表格
使我的想法能成真
謝謝
範例如下
學生成績 教師授課資料
901 12 甲 80 王老師:901 904
902 12 丙 70 陳老師:902 904
903 12 丁 90 李老師:902 903
904 12 己 80 吳老師:903 904
即表格會跑出
王老師
901 12 甲 80
904 12 己 80
陳老師
902 12 丙 70
904 12 己 80
李老師
902 12 丙 70
903 12 丁 90
吳老師
903 12 丁 90
904 12 己 80
感謝大家的大恩大德
協助思考和處理大資料量:)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.192.27.28
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1482839936.A.C44.html
※ 編輯: useptt (123.192.27.28), 12/27/2016 21:34:48
→
12/28 00:56, , 1F
12/28 00:56, 1F
→
12/28 21:59, , 2F
12/28 21:59, 2F
→
12/28 21:59, , 3F
12/28 21:59, 3F
→
12/28 22:00, , 4F
12/28 22:00, 4F
→
12/28 22:00, , 5F
12/28 22:00, 5F
→
12/28 22:01, , 6F
12/28 22:01, 6F
→
12/28 22:02, , 7F
12/28 22:02, 7F
→
12/28 22:02, , 8F
12/28 22:02, 8F
→
12/28 22:02, , 9F
12/28 22:02, 9F
→
12/28 22:03, , 10F
12/28 22:03, 10F
→
12/28 22:03, , 11F
12/28 22:03, 11F
→
12/28 22:14, , 12F
12/28 22:14, 12F
→
12/28 22:15, , 13F
12/28 22:15, 13F
→
12/28 22:15, , 14F
12/28 22:15, 14F
→
12/28 22:17, , 15F
12/28 22:17, 15F
→
12/28 22:19, , 16F
12/28 22:19, 16F
→
12/28 22:22, , 17F
12/28 22:22, 17F
→
12/28 22:29, , 18F
12/28 22:29, 18F
→
12/28 22:36, , 19F
12/28 22:36, 19F
→
12/28 22:36, , 20F
12/28 22:36, 20F
→
12/28 22:36, , 21F
12/28 22:36, 21F
→
12/28 22:37, , 22F
12/28 22:37, 22F
→
12/28 22:38, , 23F
12/28 22:38, 23F
→
12/28 22:44, , 24F
12/28 22:44, 24F
→
12/28 23:00, , 25F
12/28 23:00, 25F
→
12/28 23:01, , 26F
12/28 23:01, 26F
→
12/28 23:04, , 27F
12/28 23:04, 27F
→
12/28 23:11, , 28F
12/28 23:11, 28F
→
12/28 23:12, , 29F
12/28 23:12, 29F
→
12/28 23:14, , 30F
12/28 23:14, 30F
→
12/28 23:17, , 31F
12/28 23:17, 31F
→
12/28 23:19, , 32F
12/28 23:19, 32F
→
12/28 23:19, , 33F
12/28 23:19, 33F
→
12/28 23:20, , 34F
12/28 23:20, 34F
→
12/28 23:20, , 35F
12/28 23:20, 35F
→
12/28 23:24, , 36F
12/28 23:24, 36F
→
12/28 23:25, , 37F
12/28 23:25, 37F
→
12/28 23:26, , 38F
12/28 23:26, 38F
→
12/28 23:28, , 39F
12/28 23:28, 39F
→
12/28 23:45, , 40F
12/28 23:45, 40F
→
12/28 23:45, , 41F
12/28 23:45, 41F
→
12/28 23:46, , 42F
12/28 23:46, 42F
→
12/28 23:48, , 43F
12/28 23:48, 43F
→
12/28 23:48, , 44F
12/28 23:48, 44F
→
12/28 23:48, , 45F
12/28 23:48, 45F
→
12/28 23:48, , 46F
12/28 23:48, 46F
→
12/28 23:55, , 47F
12/28 23:55, 47F
→
12/28 23:55, , 48F
12/28 23:55, 48F
→
12/28 23:57, , 49F
12/28 23:57, 49F
→
12/28 23:58, , 50F
12/28 23:58, 50F
→
12/29 00:02, , 51F
12/29 00:02, 51F
→
12/29 00:12, , 52F
12/29 00:12, 52F
→
12/29 00:14, , 53F
12/29 00:14, 53F
→
12/29 00:14, , 54F
12/29 00:14, 54F
→
12/29 00:16, , 55F
12/29 00:16, 55F
→
12/29 00:17, , 56F
12/29 00:17, 56F
→
12/29 00:17, , 57F
12/29 00:17, 57F
→
12/29 00:18, , 58F
12/29 00:18, 58F
→
12/29 00:18, , 59F
12/29 00:18, 59F
→
12/29 00:18, , 60F
12/29 00:18, 60F
→
12/29 00:20, , 61F
12/29 00:20, 61F
→
12/29 00:21, , 62F
12/29 00:21, 62F
→
12/29 00:21, , 63F
12/29 00:21, 63F
→
12/29 00:22, , 64F
12/29 00:22, 64F
→
12/29 00:23, , 65F
12/29 00:23, 65F