请教一个EXCEL中的问题,如何把一张全体花名册中的个人信息导入另一张单独的个人信息表中? excel种如何把一张表的一个人多行信息倒到另一张表的中
\u5982\u4f55\u5c06\u4e00\u5f20excel\u8868\u4e2d\u7684\u4fe1\u606f\u5bfc\u5165\u5230\u53e6\u5916\u4e00\u5f20\u8868\u683c\u4e2d\u3002excel\u6bcf\u5217\u5206\u522b\u662f\u59d3\u540d\u3001\u5e74\u9f84\u3001\u804c\u4e1a\u7b49\u4fe1\u606f\u3002\u5982\u679c\u662f\u6309\u7167\u56fa\u5b9a\u6a21\u677f\u586b\u5199\u7684\u8bdd
\u5efa\u8bae\u5b66\u4e60\u4e00\u4e0bword\u4e2d\u7684\u90ae\u4ef6\u5408\u5e76\u529f\u80fd
\u5012\u662f\u53ef\u4ee5\u5feb\u901f\u89e3\u51b3\u6b64\u7c7b\u95ee\u9898\uff01
\u7b2c\u4e00\u79cd\u65b9\u6cd5\uff1a
\u9009\u4e2d\u6570\u636e\u533a\u57df\uff0c\u6392\u5e8f\uff0c\u7136\u540e\u9009\u53d6\u4e00\u4e2a\u4eba\u7684\u6240\u6709\u4fe1\u606f\u590d\u5236\uff0c\u7c98\u8d34\u5230\u53e6\u4e00\u8868\u4e2d\u3002
\u7b2c\u4e8c\u79cd\u65b9\u6cd5\uff1a
\u9009\u4e2d\u6570\u636e\u533a\u57df\u7b2c\u4e00\u884c\uff0c\u6309\u201c\u6570\u636e\uff0d\u7b5b\u9009\uff0d\u81ea\u52a8\u7b5b\u9009\u201d\uff0c\u5c31\u4f1a\u51fa\u73b0\u5411\u4e0b\u7bad\u5934\uff0c\u70b9\u51fb\u8fd9\u4e2a\u7bad\u5934\uff0c\u9009\u67d0\u4e2a\u4eba\uff0c\u8fd9\u4e2a\u4eba\u7684\u4fe1\u606f\u5c31\u5168\u90e8\u51fa\u6765\u4e86\uff0c\u5176\u4ed6\u4eba\u7684\u5c31\u81ea\u52a8\u9690\u85cf\uff0c\u7136\u540e\u9009\u53d6\u8fd9\u4eba\u7684\u6240\u6709\u4fe1\u606f\u590d\u5236\uff0c\u7c98\u8d34\u5230\u53e6\u4e00\u8868\u4e2d\u3002
复制粘贴就行了,要是其他的也有excel的导入功能
http://zhidao.baidu.com/question/586447263.html?oldq=1
如何将花名册的信息导入个人登记表
绛旓細寰堝鏄撳疄鐜伴渶瑕佺殑鍔熻兘銆傚弬鑰冨乏鍥 鐢佃剳浣跨敤娴佹按 閮ㄥ垎锛屽缓绔嬩娇鐢ㄧ殑鍩虹淇℃伅锛堟敞鎰忔暟鎹竴瀹氳瑙勮寖锛屾瘮濡閲岄潰鐨鏃堕棿鏃ユ湡鏍煎紡灏卞繀椤绘槸excel璁ゅ彲鐨勶紝涓嶈兘鑷繁闅忎究鏀癸紝濡傛灉瑕佹敼锛屼竴瀹氳鏈夊姙娉曡绠楋紝涓嶇劧鍚庨潰娌℃硶鐜╋紒锛夈傜劧鍚庡啀鍙充晶鍖哄煙浣跨敤鎵嬪伐+鑷姩缁熻鐨勬柟寮忓緱鍑洪渶瑕佺殑鏁版嵁琛ㄣ傛搷浣滄楠わ細1銆佸鍒跺鍚嶅垪锛岀劧鍚庝娇鐢...
绛旓細鏂规硶1锛氱敤VBA鎻愬彇姣忎釜琛ㄧ殑鍐呭 鏂规硶2锛氱敤鏁版嵁閫忚琛ㄥ琛ㄨ仈鍚堟煡璇 鏂规硶3锛氱敤鍏紡锛屽湪涓涓鏂囦欢涓涓〃濂藉啓涓鐐癸紝璺ㄦ枃浠舵湁鐐归夯鐑
绛旓細E1鍗曞厓鏍煎啓鍏紡锛=IFERROR(INDEX(A:A,MATCH(F1,B:B,0)),"")涓嬫媺濉厖鍏紡鍗冲彲銆
绛旓細鍋囪鏁版嵁鍦ˋ鍒楃殑A1鑷矨1000鍗曞厓鏍 鍒橞1鍗曞厓鏍煎啓鍏ュ叕寮 =INDEX(A:A,SMALL(IF(MATCH(A$1:A$1000&"",A$1:A$1000&"",)=ROW($1:$1000),ROW($1:$1000),4^8),ROW(A1)))&""鏁扮粍鍏紡,鎸変笅SHIFT+CTRL+ENTER涓夐敭,涓嬫媺濉厖鍏紡
绛旓細棣栧厛锛岄夋嫨A3涓嶣3锛屽彸閿紝鈥滆缃崟鍏冩牸鏍煎紡鈥濓紝鍒囨崲鍒扳滀繚鎶も濋夐」鍗★紝鍙栨秷鈥滈攣瀹氣濈殑鍕鹃夛紝纭畾銆傜劧鍚庯紝鐐瑰嚮鈥滃闃呪-鈥滀繚鎶ゅ伐浣滆〃鈥濓紝杈撳叆瀵嗙爜锛岀‘瀹氥
绛旓細1銆佸皢a鍒楃殑鏁版嵁澶嶅埗鍒癲鍒楋紝閫夊畾d鍒楋紝鐐硅彍鍗曗啋鏁版嵁鈫掑垹闄ら噸澶嶉」锛涳紙閫夐」锛氬綋鍓嶅尯鍩燂級2銆乪2杈撳叆锛=sumif($a:$a,$d2,b:b) 鍙虫媺鍒癴2锛岄夊畾姝や袱鏍间笅鎷夛紱3銆佹妸e銆乫鍒楃殑缁撴灉澶嶅埗锛岄夋嫨鎬х矘璐达紙閫夐」鏁板硷級鍒板師浣嶇疆锛坋f鍒楋級銆
绛旓細涔熷彲浠ヨ繖鏍凤紝瀵逛簬鏃ユ湡锛屽彲鐢ㄥ嚱鏁锛屽A4鍗曞厓鏍艰緭鍏ワ細=A1+1 锛圓1锛孉2锛孉3灏变汉宸ヨ緭鍏ユ棩鏈燂級鍏跺畠锛岀敤宸ュ叿-閫夐」-鑷畾涔夊簭鍒 鍏堢紪杈戜綘瑕佺殑鏍煎紡锛岀劧鍚庣偣 鑷畾涔夊簭鍒 瀵煎叆 鏃佽竟鐨勬寜閽-閫夋嫨浣犵紪杈戠殑鏍煎紡鍗曞厓鏍硷紝鐒跺悗閫夊鍏ワ紝纭畾銆傝繖鏍蜂互鍚庤繖绉嶆牸寮忓氨鑳界敤鎷栨潵瀹屾垚銆備互鍚庨夋嫨涓鍒楁嫋锛屽氨鍙互浜 濡傚浘 ...
绛旓細涓娆=INDEX(A:A,SMALL(IF(COUNTIF($A$1:$A$6,$A$1:$A$6)=1,ROW($A$1:$A$6),4^8),ROW(A1)))浜屾 =INDEX(A:A,SMALL(IF(COUNTIF($A$1:$A$6,$A$1:$A$6)=2,ROW($A$1:$A$6),4^8),ROW(A1)))涓夋 =INDEX(A:A,SMALL(IF(COUNTIF($A$1:$A$6,$A$1:$A$...
绛旓細涓嶇鏄帓搴忓摢涓鍒楋紝鍏朵粬鍒楄偗瀹氫篃浼氳窡鐫涓璧峰姩鐨勩備綘鍙互鍦˙鍒楄繕鏈帓搴忓墠鍏堝湪C鍒楁坊鍔犱负杈呭姪鍒楁潵鎿嶄綔銆傚锛氬湪C2涓緭鍏1锛孋3涓緭鍏2锛屼竴鐩存嫋鍒版渶鍚庝竴琛锛屽C100銆傜劧鍚庡啀鎺掑簭B鍒楀苟鍒犻櫎閲嶅鐨勬暟鎹紝鍒犻櫎濂藉悗锛屽啀瀵笴鍒楀崌搴忔帓搴忥紝灏卞彲浠ユ仮澶嶆甯哥殑椤哄簭銆
绛旓細寰椾娇鐢ㄥ叾瀹冩搷浣滄柟娉曘備笅闈㈡彁渚沄BA闅旇鎻掑叆绌鸿鐨勪唬鐮侊細Dim a As IntegerDim b As Integera = WorksheetFunction.CountA(Range("a:a"))b = 2For x = 1 To aRows(b & ":" & b).SelectSelection.Insert Shift:=xlDownb = b + 2Next 灏嗗涓婁唬鐮佷綔涓哄畯锛屽湪Excel涓杩愯鍗冲彲銆