請問這裏有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

請您先登陸,再發跟帖!

發現Adblock插件

如要繼續瀏覽
請支持本站 請務必在本站關閉/移除任何Adblock

關閉Adblock後 請點擊

請參考如何關閉Adblock/Adblock plus

安裝Adblock plus用戶請點擊瀏覽器圖標
選擇“Disable on www.wenxuecity.com”

安裝Adblock用戶請點擊圖標
選擇“don't run on pages on this domain”