1. 文学城
  2. [computer]

请问这里有excel expert? I need help! n7002012-09-24 21:29:40

n7002012-09-24 21:29:40

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?

wooddiy2012-09-24 21:42:27
Not exactly sure, but why it can't be done?
n7002012-09-24 21:56:32
I don't want to link hundreds of times. Is there anyway
slow_quick2012-09-24 22:41:54
don't understand why you need to link anything
n7002012-09-24 23:10:30
Sorry I don't know how to write code, is this the code for macro
tianfangye2012-09-24 23:29:05
very simple. just COPY 58 tabs to another 58 tabs sheet, then f
slow_quick2012-09-24 23:54:43
VBA很容易学
txhomemaker2012-09-25 00:57:58
vlookup? hlookup?
wooddiy2012-09-25 16:43:38
Then you have to learn VB coding and do "loop"
LaoWong2012-09-25 19:31:55
Copy & Paste
slow_quick2012-09-25 19:33:53
你要说得跟具体些大家才能给建议
wshry2012-09-30 20:53:42
回复：请问这里有excel expert? I need help!
继续阅读
请大侠推荐小孩练习键盘的软件westernland   2012-09-24 17:05:24误升iOS 6.0 还有办法退回去吗？Coorslight969   2012-09-24 17:04:18请教该买什么样的电脑猛牛   2012-09-24 00:55:07请问哪位有PC版MAC OS安装经验？WINXP Laptop PC BASEtianfangye   2012-09-23 15:33:04紧急求救：iPhone 4S 和iPad 2 升级以后用 safari上网查yahoo email时caixiaduoduo   2012-09-23 09:45:40Dell 的手提换了电池也没用，半小时就烫的要命，是什么问题呀？？？jade168   2012-09-23 06:53:01小米手机可以用在加拿大的CDMA网上企鹅肥肥   2012-09-23 05:14:35求救: iPhone 4s 升级后不能上网, wifi键是灰色的，不能打开coffee   2012-09-23 04:30:42哪位能给点建议？ 先谢!!!stocktiming   2012-09-22 21:52:12LAPTOP的屏幕被我踩坏了,换一个要$130,好像不值,能接到DESKTOP的显示屏吗?LWL   2012-09-22 17:10:17
同作者
请问这里有excel expert? I need help!n700   2012-09-24 21:29:40