請問這裏有excel expert? I need help!

來源: n700 於 2012-09-24 13:29:40 [] [舊帖] [給我悄悄話] 閱讀數 : (194 bytes)

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?

所有跟帖： 

• Not exactly sure, but why it can't be done? -wooddiy- ♂ 給 wooddiy 發送悄悄話 wooddiy 的博客首頁 (338 bytes) () 09/24/2012 postreply 13:42:27

• I don't want to link hundreds of times. Is there anyway -n700- ♀ 給 n700 發送悄悄話 (28 bytes) () 09/24/2012 postreply 13:56:32

• Then you have to learn VB coding and do "loop" -wooddiy- ♂ 給 wooddiy 發送悄悄話 wooddiy 的博客首頁 (86 bytes) () 09/25/2012 postreply 08:43:38

• don't understand why you need to link anything -slow_quick- ♂ 給 slow_quick 發送悄悄話 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- ♀ 給 n700 發送悄悄話 (0 bytes) () 09/24/2012 postreply 15:10:30

• VBA很容易學 -slow_quick- ♂ 給 slow_quick 發送悄悄話 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- ♂ 給 tianfangye 發送悄悄話 tianfangye 的博客首頁 (0 bytes) () 09/24/2012 postreply 15:29:05

• vlookup? hlookup? -txhomemaker- ♀ 給 txhomemaker 發送悄悄話 (0 bytes) () 09/24/2012 postreply 16:57:58

• Copy & Paste -LaoWong- ♂ 給 LaoWong 發送悄悄話 LaoWong 的博客首頁 (200 bytes) () 09/25/2012 postreply 11:31:55

• 你要說得跟具體些大家才能給建議 -slow_quick- ♂ 給 slow_quick 發送悄悄話 slow_quick 的博客首頁 (0 bytes) () 09/25/2012 postreply 11:33:53

• 回複：請問這裏有excel expert? I need help! -wshry- ♂ 給 wshry 發送悄悄話 (34 bytes) () 09/30/2012 postreply 12:53:42

請您先登陸，再發跟帖！