从另外一个excel的worksheet中复制数据是否能被看出来
\u590d\u5236Excel\u8868\u683c\u65f6\u600e\u6837\u53ea\u590d\u5236\u6570\u636e\u590d\u5236\u540e\u70b9\u51fb\u9f20\u6807\u53f3\u952e\u9009\u62e9\u53ea\u7c98\u8d34\u503c\u5373\u53ef\uff0c\u64cd\u4f5c\u6b65\u9aa4\u5982\u4e0b\uff1a
\u5de5\u5177\uff1a2010\u7248excel
1\u3001\u5148\u6253\u5f00excel\uff0c\u4ee5\u4e0b\u56fe\u4e3a\u4f8b\uff0cC\u5217\u662f\u6709\u516c\u5f0f\u7684\uff0c\u73b0\u9700\u590d\u5236\u5230\u5176\u4ed6\u5355\u5143\u683c\u540e\u53ea\u590d\u5236\u6570\u503c\uff1b
2\u3001\u5168\u90e8\u9009\u4e2d\u9700\u8981\u590d\u5236\u7684\u5355\u5143\u683c\uff0c\u7136\u540e\u6309Ctrl+C\u952e\u590d\u5236\uff1b
3\u3001\u9009\u4e2d\u9700\u8981\u653e\u7f6e\u590d\u5236\u540e\u6570\u636e\u7684\u5355\u5143\u683c\uff0c\u5982\u4e0b\u56fe\u4e2d\u7684F2\u5355\u5143\u683c\uff0c\u7136\u540e\u70b9\u51fb\u9f20\u6807\u53f3\u952e\uff0c\u9009\u62e9\u53ea\u7c98\u8d34\u503c\uff0c\u5373\u70b9\u51fb\u6570\u5b57\u201c123\u201d\u90a3\u4e2a\u9009\u9879\uff1b
4\u3001\u6700\u540e\u53ef\u4ee5\u770b\u5230\u590d\u5236\u7684\u516c\u5f0f\u90fd\u53d8\u6210\u6570\u503c\u4e86\u3002
\u4f60\u597d\uff01\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u4f60\u53ea\u8981\u5220\u9664\u8fd9\u4e2a\u6587\u4ef6\u5939 "XLSTART\u201d\uff0c\u5373\u53ef\u3002\u6211\u7684\u64cd\u4f5c\u7cfb\u7edf\u662fWindows XP Pack 3\uff0c\u5177\u4f53\u8def\u5f84\u662f
C:\Documents andSettings\Administrator\Application Data\Microsoft\Excel\XLSTART
\u5220\u9664\u540e\uff0c\u7535\u8111\u91cd\u65b0\u542f\u52a8\u4e0b\u3002\u7136\u540e\u518d\u6253\u5f00Excel\u3002
\u56e0\u64cd\u4f5c\u7cfb\u7edf\u4e0d\u540c\uff0c\u8def\u5f84\u6709\u6240\u5dee\u5f02\uff0c\u4e0d\u8fc7\u5e2e\u670b\u53cb\u4e5f\u89e3\u51b3\u4e86\u7c7b\u4f3c\u95ee\u9898\uff0c\u4ed6\u662fvista\u7cfb\u7edf\uff0c\u4e5f\u662f\u5220\u9664\u7cfb\u7edf\u76d8\u4e0b\u7684XLSTART\u6587\u4ef6\u5939\uff0c\u5177\u4f53\u8def\u5f84\u4e0d\u592a\u8bb0\u5f97\u5566\uff0c\u60a8\u641c\u7d22\u4e0b\u5c31\u53ef\u4ee5\u3002
\u795d\u4f60\u89e3\u51b3\u8fd9\u4e2a\u607c\u4eba\u7684\u95ee\u9898\uff0c\u89e3\u51b3\u4e86\u8bb0\u5f97\u7ed9\u5206\u6253\u8d4f\u54e6\uff5e
绛旓細1銆侀鍏堬紝鍦Excel涓鎸夊揩鎹烽敭鈥淎lt + F11鈥濓紝濡備笅鍥炬墍绀恒2銆佸叾娆★紝鍦╒BA缂栬緫鍣ㄤ腑渚濇鍗曞嚮鈥滄彃鍏モ-->鈥滄ā鍧椻濓紝濡備笅鍥炬墍绀恒3銆佺劧鍚庯紝鍦ㄢ滄ā鍧椻濅腑杈撳叆濡備笅浠ｇ爜锛歄ption Explicit Sub addwork()Sheets.Add after:=Sheets(Sheets.Count)End Sub 4銆佹帴鐫锛屽湪VBA缂栬緫鍣ㄧ殑宸︿晶杈撳叆妯″潡鐨勫悕绉帮紝濡備笅...
绛旓細棣栧厛锛屽惎鍔Excel锛岄氳繃蹇嵎閿瓵lt+f11蹇熻繘鍏BA缂栬緫鍣ㄣ傚湪缂栬緫鍣ㄧ殑鐣岄潰涓紝鎵惧埌骞剁偣鍑婚《閮ㄨ彍鍗曠殑鈥滄彃鍏モ濓紝鎺ョ潃閫夋嫨鈥滄ā鍧椻濓紝杩欏皢涓轰綘鍒涘缓涓涓鏂扮殑缂栫▼鐜銆傚湪鏂板垱寤虹殑妯″潡涓紝浣犻渶瑕佽緭鍏ヤ互涓媀BA浠ｇ爜浠ュ疄鐜版坊鍔犲伐浣滆〃鐨勫姛鑳斤細OptionExplicitSubaddwork()Sheets.AddAfter:=Sheets(Sheets.Count)EndSub杩...
绛旓細Excel涓瓀orkday.intl鍑芥暟鐨勮繍鐢ㄦ柟娉曞涓:鍑芥暟璇存槑銆1銆佸嚱鏁拌娉曪細WORKDAY.INTL(start_date,days,weekend,holidays)2銆佸嚱鏁拌鏄庯細start_date锛氳〃绀哄紑濮嬫棩鏈;days锛氳〃绀哄湪鍙傛暟Start_date涔嬪墠鎴栦箣鍚庢寚瀹氱殑宸ヤ綔鏃ュぉ鏁;weekend锛氳〃绀轰笉鍖呭惈鍦ㄦ墍鏈夊伐浣滄棩鏁颁腑鐨勭壒瀹氬懆鏈棩鐨勫弬鏁板;holidays锛氳〃绀洪渶瑕佹帓闄ゅ湪澶栫殑鑺傚亣...
绛旓細鍦Excel涓锛屽埄鐢╒BA缂栫▼宸ュ叿鍙互鏂逛究鍦版坊鍔犳柊鐨勫伐浣滆〃骞朵负鍏跺懡鍚嶃備互涓嬫槸璇︾粏鐨勬楠ゆ寚瀵硷細棣栧厛锛屽惎鍔‥xcel锛屾寜涓嬮敭鐩樹笂鐨勨淎lt+F11鈥濈粍鍚堥敭锛岃繖灏嗘墦寮VBA缂栬緫鍣紝濡傚浘鎵绀恒傛帴涓嬫潵锛屼綘闇瑕佸湪VBA缂栬緫鍣ㄧ殑鐣岄潰涓垱寤涓涓鏂扮殑鎿嶄綔妯″潡銆傚湪鑿滃崟鏍忎腑閫夋嫨鈥滄彃鍏モ濋夐」锛岀劧鍚庨夋嫨鈥滄ā鍧椻濓紝濡傚浘鎵绀恒傚湪鏂板垱寤虹殑...
绛旓細鐪excel閲涓涓獁orkbook閲屾湁澶氬皯workshe鎸変互涓嬫楠ゆ煡鎵俱傛墦寮闇瑕佺紪杈戠殑excel锛岀偣鍑绘煡鎵惧拰閫夋嫨閫夐」銆1銆佸湪璇ラ〉闈腑鐐瑰嚮鏌ユ壘閫夋嫨銆2銆佷箣鍚庡湪璇ラ〉闈腑鍦ㄨ寖鍥村彸渚х偣鍑婚夋嫨宸ヤ綔绨块夐」銆3銆佸湪璇ラ〉闈腑杈撳叆瑕佹煡鎵剧殑鍐呭鐒跺悗鐐瑰嚮鏌ユ壘鍏ㄩ儴閫夐」銆4銆佸湪璇ラ〉闈㈠彲浠ョ湅瑙佹墍鏈夊伐浣滆〃浜嗐
绛旓細绗竴姝ワ細鍗曞嚮鈥滃伐鍏封澛封滀俊鍑戒笌閭欢鈥澛封滈偖浠跺悎骞垛濓紝浠诲姟绐楁牸路鈥滈偖浠跺悎骞垛濓紱绗簩姝ワ細鍦ㄢ滈夋嫨鏂囨。绫诲瀷閫夐」鍖衡濅腑閫夊畾鈥滀俊鍑解濓紝鐒跺悗鍗曞嚮鈥滀笅涓姝ワ細姝ｅ湪鍚姩鏂囨。鈥濓紱绗笁姝ワ細鍦ㄢ滈夋嫨寮濮嬫枃妗ｂ濋夐」鍖猴紝閫夊畾鈥滀娇鐢ㄥ綋鍓嶆枃妗ｂ濓紝鐒跺悗鍗曞嚮鈥滀笅涓姝ワ細閫夊彇鏀朵欢浜衡濓紝鐒跺悗閫夋嫨鈥滀娇鐢ㄧ幇鏈夊垪琛ㄢ濄傜偣鍑烩...
绛旓細绗竴姝ワ紝璋冪敤WORKDAY.INTL鍑芥暟锛屼篃灏辨槸鍦ㄦ寚瀹氬崟鍏冩牸涓緭鍏モ=WORKDAY.INTL鈥濓紱杈撳叆杩囩▼涓璄xcel鑷姩鏄剧ず鍑芥暟鍔熻兘锛涚浜屾锛岃瀹氬弬鏁皊tart_date锛屾寚瀹氭棩鏈燂紱绗笁姝ワ紝璁惧畾days锛屼箣鍓嶆垨涔嬪悗鐨勫ぉ鏁帮紝涔嬪悗涓烘鏁帮紝涔嬪墠涓鸿礋鏁帮紱绗洓姝ワ紝鎸囧畾鍛ㄦ湯锛岃寰楀弬鏁板彇鍊艰寖鍥存槸鍥哄畾鐨勶紱绗簲姝ワ紝璁惧畾鍛ㄦ湯鏃ユ湡锛涚鍏锛岀偣鍑...
绛旓細Sub Work_copy()Dim a As Range Dim i As Long Dim xls1 As Worksheet Dim xls2 As Worksheet Set xl1 = Workbooks("婧愭枃浠").Worksheets("婧愬伐浣滆〃")i = xl1.Index '杩斿洖婧愬伐浣滆〃鐨勭储寮曞彿 Set xl2 = Workbooks("鐩爣鏂囦欢").Worksheets(i)a = Application.InputBox("閫夋嫨瑕佸鍒剁殑鍗曞厓...
绛旓細1.閫氳繃瑕佽繘琛屽姣旂殑涓や釜宸ヤ綔琛ㄦ垨澶氫釜宸ヤ綔琛ㄤ綅浜庝笉鍚岀殑鏂囦欢涓紝棣栧厛瑕佸仛鐨勫氨鏄綋澶氫釜瑕佽繘琛屽姣旂殑Excel宸ヤ綔琛ㄦ暟鎹鍒剁矘璐村埌鍚涓涓宸ヤ綔琛ㄤ腑锛屽悓鏃跺仛濂藉悇涓伐浣滆〃鐨勫懡鍚嶅噯澶囷紝浠ヤ究鑳芥纭殑鍖哄垎鏁版嵁鐨勬潵婧愩2.鎺ヤ笅鏉ョ‘瀹氭暟鎹滃叧閿瓧鈥濋儴鍒嗭紝鍗宠兘澶熷敮涓鏍囪瘑璁板綍鐨勫叧閿瓧缁勫悎锛岃繖鏍峰氨鍙互鍦ㄨ繘琛屾暟鎹姣旀椂锛...
绛旓細浣跨敤INDIRECT鍑芥暟瑙ｅ喅鍗冲彲銆傚皢鍏紡鏇存敼涓=VLOOKUP(F1,INDIRECT("'D:\WORK\TOOL\MO\["&$A$1&".xls]Sheet1!$B:$C"),2,0)INDIRECT灞炴ц繑鍥炵敱鏂囨湰瀛楃涓叉寚瀹氱殑寮曠敤銆傛鍑芥暟绔嬪嵆瀵瑰紩鐢ㄨ繘琛岃绠楋紝骞舵樉绀哄叾鍐呭銆傚綋闇瑕佹洿鏀瑰叕寮忎腑鍗曞厓鏍肩殑寮曠敤锛岃屼笉鏇存敼鍏紡鏈韩锛岃浣跨敤鍑芥暟INDIRECT銆傝娉旾NDIRECT(ref_...
