é¦å ï¼ç¡®å®ä½ è¦å¾å°æ¯å·¥ä½è¡¨å称ï¼ç±»ä¼¼é»è®¤æå¼æ件éçSheet1ãSheet2â¦â¦ï¼ï¼èä¸æ¯å·¥ä½ç°¿å称ã
使ç¨VBAæ¹ä¾¿
é便å³å»ä¸ä¸ªå·¥ä½è¡¨æ ç¾ï¼å·¦ä¸è§ï¼ï¼éæ©âæ¥ç代ç âãæè æ Alt+F11ï¼å¹¶åå»å ¶ä¸ä¸ä¸ªSheetã
å¤å¶ä¸é¢ç代ç ï¼
Sub a()ç¹å»F5è¿è¡ï¼ç»ææ¾ç¤ºå¨âç«å³çªå£ä¸âï¼å¦ä¸å¾ãå¦æ没æçå°ç«å³çªå£ï¼å¯ä»¥å¨âè§å¾âèåæ¾å°ï¼æCtrl+Gè°åºæ¥ï¼