軟體:EXCEL
版本:97-2003
A B C
1 A B
2
3
4
5
6
7
8
9
10
11
12
13
14 sheet4!A1 sheet4!B1
15 sheet4!A2 sheet4!B2
16 sheet4!A3 sheet4!B3
17 sheet4!A4 sheet4!B4
18 sheet4!A5 sheet4!B5
19 sheet4!A6 sheet4!B6
20 sheet4!A7 sheet4!B7
21 sheet4!A8 sheet4!B8
22 sheet4!A9 sheet4!B9
有沒有方法可以在B1打上A，下方A14的公式就能變成Sheet4!A1
在C1打上B，下方A14的公式就能變成Sheet4!B1