Not exactly sure, but why it can't be done?

来源: wooddiy 2012-09-24 13:42:27 [] [博客] [旧帖] [给我悄悄话] 本文已被阅读: 次 (338 bytes)
回答: 请问这里有excel expert? I need help!n7002012-09-24 13:29:40

You know how to call data from different tabs, so you list the data from 58 tabs in the 59th tab, and set whatever format you want in the 50th tab.

You don't need to follow the format of other 58 tabs.

for exampe: ='tab12!'B12 (or similar calling)

=[pathtoWorkboolX.xls]sheetname!cellReference

所有跟帖: 

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

请您先登陆,再发跟帖!

发现Adblock插件

如要继续浏览
请支持本站 请务必在本站关闭/移除任何Adblock

关闭Adblock后 请点击

请参考如何关闭Adblock/Adblock plus

安装Adblock plus用户请点击浏览器图标
选择“Disable on www.wenxuecity.com”

安装Adblock用户请点击图标
选择“don't run on pages on this domain”