ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¨Ì¤é´Á¦Û°Ê¿ï¨ú¤u§@ªí¡H

[µo°Ý] ¦p¦ó¨Ì¤é´Á¦Û°Ê¿ï¨ú¤u§@ªí¡H

¥»©«³Ì«á¥Ñ ymes ©ó 2021-7-15 15:34 ½s¿è

°ÝÃD¦pªþ¥ó¡A½Ð°Ý¡G¦p¦ó§Q¥Î¤é´Á¿ï¨ú¸ê®Æ¡H
¦p¡G[¤C¤ë]¤u§@ªí¤¤7/22¤é¿é¤J¡G®a±Ú»E·|¡A
¦b[§e²{ªí®æ]¤¤7/22¶]¥X®a±Ú»E·|
³Â·Ð¦U¦ì¤j¤jÀ°¦£°Ê¸£¤@¤U¡A·PÁ¡I

000.png (13.39 KB)

000.png

°O¨Æ¤ë¾ä.zip (30.77 KB)

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

1) ¤ë¾ä¥i¯à¦³¸ó¦~, ¤u§@ªí¦WºÙ§ï¦¨ yyyy.mm ¤å¦r®æ¦¡
2) ¤½¦¡­Y¹J©|¥¼«Ø¥ßªº¤ë¥÷µo¥Í¿ù»~, ¦Û¦æ¥[ iferror ±Æ°£

Xl0000680.rar (13.26 KB)

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁ±z¡A¬O§Ú©Ò­nªº¡AÁ¿¸Ñ¤]«Ü²M·¡¡A

«á­±¦A¥[¤W¤u§@ªí¡A¤]¥i¥H§e²{¥X¨Ó¡A

¦ý³oÀÉ®×·Q¥Î10¦~*12­Ó¤ë¡A·|¥X²{120¥H¤Wªº¤u§@ªí(¹L´Á¥i¥H隠ÂÃ)

¦A½Ð°Ý¤@¤U¡G
¤u§@ªí¦WºÙ2021.07§ï¦¨2107­n«ç»ò§ï©O¡H(¦è¤¸¦~+¤ë)
(©Î§ï¦¨007¤]¥i¥H)(°ê¾ä110¦~7¤ë)
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 3# ymes

2107, 2108~~~
=INDEX(INDIRECT("'"&RIGHT($A$1*100+$C$1,4)&"'!A1:G13"),ROW($A3),COLUMN(A$1))&""

TOP

¦^´_ 4# ­ã´£³¡ªL

¦¨¥\¤F¡A¦n¹³¬ÝÀ´¤F¤@¨Ç¡A

·PÁ¡I°J¤ß·PÁ¡I

:lol :lol :lol
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_  ymes

2107, 2108~~~
=INDEX(INDIRECT("'"&RIGHT($A$1*100+$C$1,4)&"'!A1:G13"),ROW($A3),COLUMN ...
­ã´£³¡ªL µoªí©ó 2021-7-17 22:21

½Ð°Ý¡G¬õ¦â³¡¥÷ªº¥Î·N¬O¡H
=INDEX(INDIRECT("'"&RIGHT($A$1*100+$C$1,4)&"'!A1:G13"),ROW($A3),COLUMN(A$1))&""
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 6# ymes


=INDEX(INDIRECT("'"&RIGHT($A$1*100+$C$1,4)&"'!A1:G13"),ROW($A3),COLUMN(A$1))&""


¨â­Ó³æ¤Þ¸¹...¦³¤u§@ªí¦WºÙ§t¦³²Å¸¹ªÅ®æ, ¥²¶·¥Î³æ¤Þ¸¹¥]ÂÐ, §_«h·|¦³¿ù»~
³Ì«áÂù¤Þ¸¹...±N¤½¦¡µ²ªGÂର¤å¦r®æ¦¡, ÁקKªÅ®æÅܦ¨0­È

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ymes ©ó 2021-7-18 13:17 ½s¿è

¦^´_ 7# ­ã´£³¡ªL

·PÁ§iª¾¡A¦ý²{¦b¤S¥X²{¤@­Ó°ÝÃD·Q½Ð±Ð¡G

·Q§Q¥ÎHYPERLINK¨Ó°µ¤u§@ªí¤¤ªº¤Á´«¡A=HYPERLINK("[Xl0000680.xls]'2107'!A3",¤u§@ªí³sµ²)

¦ý¸Õ¤F´X¦¸¡A³£µLªk¥Î±zªº¤èªk°ÊºA³sµ²¨ì¤u§@ªí¤¤¡A¥i¥H¦A«ü±Ð¤@¤U¶Ü¡H·PÁ¡I

===============================================================
¥t¥~¡A¤]ÁÂÁÂhcm19522¤j¤jªºÀ°¦£¡A­ì¥»¬O¥Î³o¤èªkªº¡A¦ý¥Î­Ó¤Q¦~¡A©È¼gªº¤Óªø¡A©Ò¥H·Q´«¦¨³oºØ¤è¦¡

¤£¹L§A³o­Óºô­¶­Ë¬O­Ó¦n¾Ç²ßexcelªº¦a¤è¡A¤w¥[¤J¦¬ÂáA·PÁ¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 9# ymes

=HYPERLINK("#'"&RIGHT($A$1*100+$C$1,4)&"'!"&ADDRESS(ROW(A3),COLUMN(A1)),INDEX(INDIRECT("'"&RIGHT($A$1*100+$C$1,4)&"'!A1:G13"),ROW($A3),COLUMN(A$1))&"")

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD