к觻
29 ԧҤ 2015, 05:14:27 *
Թյ͹Ѻس, ؤŷ س к ŧ¹

кªͼ ʼҹ ʪ
:
 
   ˹á   к ѤҪԡ  
˹: [1]   ŧҧ
   
¹ Ǣ: ҡҺԸ觢sheet Microsoft Excel  (ҹ 20833 )
0 Ҫԡ 1 ؤŷ ѧǢ͹
prik
ؤŷ
« : 24 ԧҤ 2006, 17:45:18 »

Shocked :Smiley Tongue Kiss >Cheesy Azn Afro
ҧҡ觢sheet ǡѹ ͧѧ
Excel ö йǷҧҧФ йӪ˹ѧͷǢͧ Wink Smiley


* 121379_1995173.jpg (89.43 KB, 350x338 - 201 .)
ѹ֡
~~
Diamond Fellowship
*****

Ե: 0
ͿŹ ͿŹ

:
з: 59



䫵
« ͺ #1 : 24 ԧҤ 2006, 19:09:19 »

Shocked :Smiley Tongue Kiss >Cheesy Azn Afro
ҧҡ觢sheet ǡѹ ͧѧ
Excel ö йǷҧҧФ йӪ˹ѧͷǢͧ Wink Smiley
㨤Ӷ Huh ѹѺ Excel ͹ѹФѺ
ѹ֡

<b>к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻</b>
A
ؤŷ
« ͺ #2 : 24 ԧҤ 2006, 19:11:34 »

¶֧ҧ field sheet ҤѺ

<sheet name>!<field> sheet1!b4
ѹ֡
prik
ؤŷ
« ͺ #3 : 25 ԧҤ 2006, 07:28:05 »

ͧӴ ͺسҡФ
ѹ֡
judas
Stager Tier 5
*****

Ե: 4
ͿŹ ͿŹ

:
з: 1,926



« ͺ #4 : 25 ԧҤ 2006, 08:34:07 »

¶֧ҧ field sheet ҤѺ

<sheet name>!<field> sheet1!b4



觵çФѺ  ǼѾѹѧͤѺ  ͸Ժ˹¤Ѻ 
ѹ֡

к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻
~~
Diamond Fellowship
*****

Ե: 0
ͿŹ ͿŹ

:
з: 59



䫵
« ͺ #5 : 25 ԧҤ 2006, 09:15:29 »


觵çФѺ ǼѾѹѧͤѺ ͸Ժ˹¤Ѻ
ѹ͡ҧԧ蹹ͧѺ ͹Ѻ " A2=A4 " ءС§ѹ褹蹧ҹѺ Wink
㹷ӹͧǡѹ ҧԧŤ ͧкص <Part Name>\<File Name>\<Sheet Name>........ Cheesy
ѹ֡

<b>к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻</b>
LiNeScoTT
Platinum Fellowship
****

Ե: 0
ͿŹ ͿŹ

:
з: 54


Chanchai


« ͺ #6 : 25 ԧҤ 2006, 09:21:31 »

='C:\book1.xls\[shett1]Sheet1'!A1

Ѻ

=Sheet1!A1-Sheet2!B2

Ѻǡѹ
ѹ֡

к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻
judas
Stager Tier 5
*****

Ե: 4
ͿŹ ͿŹ

:
з: 1,926



« ͺ #7 : 25 ԧҤ 2006, 09:59:45 »

Եҧԧ sheet ФѺҢŨҡsheet  A ҷ B
Ҥ觹 sheet B ǤѺ

ԵҧԧФѺ ԧҡ A B ¤ B ͹ A ФѺ
Ҩ繵ͧԴ 2 ѹ»ǤѺԴ B 繵ͧԴ A Ѻ


Һ㨶١ǤѺ  ª˹¤Ѻ
ѹ֡

к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻
~~
Diamond Fellowship
*****

Ե: 0
ͿŹ ͿŹ

:
з: 59



䫵
« ͺ #8 : 25 ԧҤ 2006, 10:12:55 »

Եҧԧ sheet ФѺҢŨҡsheet A ҷ B
Ҥ觹 sheet B ǤѺ
Ѻ Wink
Ҩ繵ͧԴ 2 ѹ»ǤѺԴ B 繵ͧԴ A Ѻ
оٵҧԧͧԴ м Huh
ҵ͹Դҹŷ B 繵ͧԴ A Ѻ AznǡѹжҨлѺاء駷Դ Angry
ѹ֡

<b>к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻</b>
the_oo
ؤŷ
« ͺ #9 : 25 ԧҤ 2006, 11:24:48 »

Ըաç ͧٵ

ͧ " = " " + " Click ѧŷյͧ link 觷سͧá͡ҤѺ
ѹ֡
~~
Diamond Fellowship
*****

Ե: 0
ͿŹ ͿŹ

:
з: 59



䫵
« ͺ #10 : 25 ԧҤ 2006, 11:45:46 »

Ըաç ͧٵ

ͧ " = " " + " Click ѧŷյͧ link 觷سͧá͡ҤѺ
ФԸշ Cool ҵͧ Grin
ѹ֡

<b>к觻 ЧѺ繵ٻҾ
͹حҵ§ 繵繢ͤ
֧Сͤ͢ ҡҪԡء ҹ
㹹 к觻</b>
prik
ؤŷ
« ͺ #11 : 25 ԧҤ 2006, 13:26:04 »

 Coolͺس
ҵ͹ sheet2
§ ͧ =
令ԡ sheet1
Ҿ觷 令ԡ㹪ͧŷͧ ǡ Enter ѹͧ
=sheet1!G8

.......Ըաù¹ŧŨҡ˹sheet1   ˹ sheet2 ¹ŧҵ仴

 AfroͧӴ س Afro
ѹ֡
˹: [1]   
   
 
ⴴ:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
˹ҹ١ҧ 0.07 Թҷ Ѻ 19