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

[µo°Ý] vlookup³t«×ºC¡A¨Ï¥Îvba¨ú¥Nªºµ{¦¡½X

¦^´_ 5# GBKEE

®M¥Î¤F§Aªºµ{¦¡½X, ¦ý¬O³t«×º¡ºCªº, ¤£ª¾¹D°ÝÃD¥X¦b¨º¨½?
¥i§_½ÐG¤jÀ°§Ú¬Ý¬Ý..
ÁÂÁÂ!!

Dictionary.rar (850.66 KB)

TOP

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

­ã¤j
¦]¬°¤£À´±o®M¥Î, ©Ò¥H¥Î¤½¦¡°µ¤F¤@­Ó½d¨Ò
¥i¥H½Ð§A§â¥¦¼g¦¨VBA¶Ü?

¸ê®Æ¦@¦³6­¶, ¨C¤@­¶³Ì¤Öªº¸ê®Æ¦³5¸Uµ§, ³Ì¦hªº¦³7¸Uµ§

Dictionary_01.rar (17.94 KB)

TOP

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

­ã¤j
§Ú¤S¹J¨ì°ÝÃD¤F...
2­Óµ{¦¡½X, ·Q±N¥¦­×§ï¦¨:
1) ¤£½×¬O¿é¤J¤j¼g©Î¤p¼g³£¥i¥H§ì¨ì¸ê®Æ
2)±j¨îPart No. ¤@©w­n§¹¾ã¿é¤J, ¤~·|§ì¨ì¸ê®Æ
3) ¦pªG"A" Äæ¬Y­Ó³æ¤¸®æ¿é¤J¿ù»~, §R°£«á, B & C Äæ³æ¤¸®æ¨½ªº¸ê®Æ¤]­n¤@°_"²M°£"

Test1.rar (16.47 KB)

TOP

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

¥i¥H¥u¹ïAÄæ³æ¤@Àx¦s®æ¿é¤J¨ú¹ïÀ³­È, ©Î¤@¦¸¶K¤J¦h­Ó¬d¸ß­È¨ú¹ïÀ³~~

  
¤ÓêɤF, ­ì¨Ó¤@½gµ{¦¡½X´N¯à¸Ñ¨Mªº¨Æ §Ú«o儍儍ªº¥H¬°­n¥Î2½g¤~¯à¹ê²{
­ã¤j§A¤Ó¤û¤F°Õ¡K
³o§¹¥þ¬O§Ú·Q­nªº®ÄªG.
°ª¿³«á, «oµo²{¦Û¤v¤£À´±o­×§ïÄæ¦ì.
¦]¬°¦³«Ü¦hExcel Àɳ£­n¥Î¨ì¦¹µ{¦¡½X
¦]¦¹¤S¦A«pÃC¤W¨Óµo°Ý.

°ÝÃD¦bªþÀÉ
bcca ÀÉ password :  1234    &   pass

wPrg.rar (65.25 KB)

TOP

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

­ã¤j
ÁÂÁ§A¤SÀ°¤F§Ú­Ó¤j¦£
1)Åý§Ú¥i¥H¥ô·N¨Ï¥Î¤£¦PªºÄæ¦ì
2)50­¶¤u§@ªí¤£¦]¤u§@ªí¦WºÙÅܰʪº°ÝÃD¸Ñ¨M¤F, §K¥h¤F»Ý­n³v­¶¥h­×§ïªº·Ð´o

·Q¦A½Ð°Ý, ¦³¨S¦³³o¼Ë²§·Q¤Ñ¶}ªº¼gªk
´N¬O·í§Ú§âwPrg¸ê®Æ½Æ»s¥hbcca ÀÉ®É,¬O§_¤]¥i¥H¦P®É­×§ï¤u§@ªí¦WºÙ¨Ã¥[¤W·í¤Ñ¤é´Á. " w_PRG_20181124"

¦]¬°¦³¤Ó¦h¹³³o¼ËªºÀÉ­n³B²z, ¦pªG¥H¤Wªº­n¨D¥i¥H¹ê²{, ¨º¹ê¦b¬O¤Ó§¹¬ü¤F.

wPrg1.rar (61.94 KB)

TOP

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

­ã¤j
¥H¤Wªº°ÝÃD¸Ñ¨M¤F, ¹ê¦b¬O¤Ó´Î¤F,¥¦Â²¤Æ¤F§Ú¤u§@ªº¬yµ{. ·P¿E!!

¤£¦n·N«ä, ÁÙ¦³¤@ÂI¤p°ÝÃD
¤§«e¨Sª`·N¨ì...

1) ·Q±N L ,M ³æ¤¸®æªº¸ê®Æ copy ¥h A & B Ä樽,
¬°¦óC , F & G ªº¸ê®Æ´N§ì¤£¥X¨Ó¤F??

2) ¦³®É·|¦]¬°¤â»~, »~§RAÄ檺¸ê®Æ, ¬°¦ó¤£¯à¥Î" Ctrl Z" Undo ­«·s¥s¥X¨Ó?

    bcca2.rar (43.29 KB)

TOP

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

¦nªº, ¦b§V¤O¾Ç²ß¤¤....

TOP

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


·Q°_©|¥¼¦^ÂЭã¤jªº°ÝÃD

CHANGEIJµoªºµ{¦¡¡A´NµLªk¦A¨Ï¥Î¡e´_­ì¡f


¤£¤F, ÁÙ¬OÅý¥¦«O¯d­ìª¬

ÁÂÁÂ!!


   








²×¤_·Q°_¨BÆJªº"ÆJ"¦r¤F..

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD