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?
请问这里有excel expert? I need help!
所有跟帖:
•
Not exactly sure, but why it can't be done?
-wooddiy-
♂
(338 bytes)
()
09/24/2012 postreply
13:42:27
•
I don't want to link hundreds of times. Is there anyway
-n700-
♀
(28 bytes)
()
09/24/2012 postreply
13:56:32
•
Then you have to learn VB coding and do "loop"
-wooddiy-
♂
(86 bytes)
()
09/25/2012 postreply
08:43:38
•
don't understand why you need to link anything
-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-
♀
(0 bytes)
()
09/24/2012 postreply
15:10:30
•
VBA很容易学
-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-
♂
(0 bytes)
()
09/24/2012 postreply
15:29:05
•
vlookup? hlookup?
-txhomemaker-
♀
(0 bytes)
()
09/24/2012 postreply
16:57:58
•
Copy & Paste
-LaoWong-
♂
(200 bytes)
()
09/25/2012 postreply
11:31:55
•
你要说得跟具体些大家才能给建议
-slow_quick-
♂
(0 bytes)
()
09/25/2012 postreply
11:33:53
•
回复:请问这里有excel expert? I need help!
-wshry-
♂
(34 bytes)
()
09/30/2012 postreply
12:53:42