请问这里有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”