m******o 发帖数: 162 | 1 Excel求教!
有两个Workshee:
Worksheet 1, 有columns A, B, C, D和lines A1, A2, A3, A4, A5, 每line分别有
column B,C, D。
Worksheet 2, 有column A, B, C, D 和lines A1, A3, A5
请教如何把Worksheet 1里lines A1, A3, A5 column B的数值import到Worksheet 2里
相对应的lines A1, A3, A5?
谢谢! | S*3 发帖数: 162 | 2 write a "=" function, refer to the cell you want. might have to use $.
EZ, just have a try.
【在 m******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Excel求教! : 有两个Workshee: : Worksheet 1, 有columns A, B, C, D和lines A1, A2, A3, A4, A5, 每line分别有 : column B,C, D。 : Worksheet 2, 有column A, B, C, D 和lines A1, A3, A5 : 请教如何把Worksheet 1里lines A1, A3, A5 column B的数值import到Worksheet 2里 : 相对应的lines A1, A3, A5? : 谢谢!
| m******o 发帖数: 162 | 3 It didn't work.
The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
on worksheet 2 don't exist on worksheet 1.
【在 S*3 的大作中提到】![](/moin_static193/solenoid/img/up.png) : write a "=" function, refer to the cell you want. might have to use $. : EZ, just have a try.
| S*3 发帖数: 162 | 4 如果你要得lines是有一定pattern的,write a function
如果是比较random从500里挑400,forget it. Do it manually.
如果有其他选择条件using other columns,do it in Access.
不好意思,你的问题还是比较泛泛,没法子给你更细致的回答。have a try
It didn't work.
The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400
lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines
on worksheet 2 don't exist on worksheet 1.
【在 m******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : It didn't work. : The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400 : lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines : on worksheet 2 don't exist on worksheet 1.
| m******o 发帖数: 162 | 5 没有pattern,不会access, wuwu
lines
【在 S*3 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 如果你要得lines是有一定pattern的,write a function : 如果是比较random从500里挑400,forget it. Do it manually. : 如果有其他选择条件using other columns,do it in Access. : 不好意思,你的问题还是比较泛泛,没法子给你更细致的回答。have a try : : It didn't work. : The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400 : lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines : on worksheet 2 don't exist on worksheet 1.
| S*3 发帖数: 162 | 6 well, a VB Macro in Excel will work.
Or try to use other stat applications if it doesn't require to keep the code
in Excel. Like STATA etc. EZ than access to learn.
Or learn access.
Otherwise, 默哀,have to do it manually as far as I know. hope there aren't
that many.
【在 m******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 没有pattern,不会access, wuwu : : lines
| z****k 发帖数: 1057 | 7 use vlookup()
lines
【在 m******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : It didn't work. : The problem is worksheet 1 has, say 500 lines, worksheet 2 has, say 400 : lines. Some lines on worksheet 1 don't exist on worksheet 2, and some lines : on worksheet 2 don't exist on worksheet 1.
| s**********l 发帖数: 629 | 8 I can't understand your question....post some examples here and I might be
able to help | g**********e 发帖数: 96 | |
|