I have 58 tabs that have data in the same format, I need some of the information from each tab put in one sheet but in different format (not combine the total), is there any way to do it?
請問這裏有excel expert? I need help!
所有跟帖:
• Not exactly sure, but why it can't be done? -wooddiy- ♂ (338 bytes) () 09/24/2012 postreply 13:42:27
• I don't want to link hundreds of times. Is there anyway -n700- ♀ (28 bytes) () 09/24/2012 postreply 13:56:32
• Then you have to learn VB coding and do "loop" -wooddiy- ♂ (86 bytes) () 09/25/2012 postreply 08:43:38
• don't understand why you need to link anything -slow_quick- ♂ (476 bytes) () 09/24/2012 postreply 14:41:54
• Sorry I don't know how to write code, is this the code for macro -n700- ♀ (0 bytes) () 09/24/2012 postreply 15:10:30
• VBA很容易學 -slow_quick- ♂ (0 bytes) () 09/24/2012 postreply 15:54:43
• very simple. just COPY 58 tabs to another 58 tabs sheet, then f -tianfangye- ♂ (0 bytes) () 09/24/2012 postreply 15:29:05
• vlookup? hlookup? -txhomemaker- ♀ (0 bytes) () 09/24/2012 postreply 16:57:58
• Copy & Paste -LaoWong- ♂ (200 bytes) () 09/25/2012 postreply 11:31:55
• 你要說得跟具體些大家才能給建議 -slow_quick- ♂ (0 bytes) () 09/25/2012 postreply 11:33:53
• 回複:請問這裏有excel expert? I need help! -wshry- ♂ (34 bytes) () 09/30/2012 postreply 12:53:42