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

vlookup¤]¥i¥H¾É¤J¹Ï¤ù¶Ü?

vlookup¤]¥i¥H¾É¤J¹Ï¤ù¶Ü?

¥»©«³Ì«á¥Ñ kengo ©ó 2014-3-27 10:24 ½s¿è

½Ð±Ð¦U¦ì¤j¤j

§Ú¦³¨â­ÓexcelÀÉ®×

ÀÉ®×A---¬O¸ê®Æ®w
ÀÉ®×B---¬O¥Îvlookup¥h§ìÀÉ®×Aªº¸ê®Æ

ÀÉ®×B¦³Äæ·Ó¤ù®æ¡A·í¼Æ¾Ú§ó§ï®É¡A·Ó¤ù¤]·|¤@°_§ó§ï


§ÚÂI¹Ï¤ù¡A¹Ï¤ù¦³Åã¥ÜCommandButton3¡A=p


·Q½Ð°Ý¬O«ç»ò°µªº¡H¡H

§Æ±æ¤j¤jµL¨p±Ð¾É¤@¤UÂP¡ã·PÁ¡I¡I

¦^´_ 6# huijuang

ÁÂÁÂÀ°§Ú§ä¥X~

¤£¹L¦³­Ó°ÝÃD~§Úª½±µ¶i¥hsunnyso¤j¤jªº[­ì³Ð] ¤À¨É - °ÊºAÅã¥Ü¹Ï¤ù(¤£¥ÎVBA)~´£°Ý

·PÁ§A!

TOP

¦^´_ 8# ANGELA

ÁÂÁ¼ö¤ßªº¤j¤j~
¤£¹LÁÙ¬O¬Ý¤£À´:'( ~
ÁÂÁÂÂP

TOP

°²³]sheet2¬O¸ê®Æ®w,AÄæ«Ø¦³¯Á¤Þ¸¹½X,CÄ榳¹Ï¤ù¡C
B2¬°¿é¤H¯Á¤Þ¸¹½Xªº¦ì¸m¡C«Ø¥ß¦WºÙP=INDIRECT("sheet2!C"&MATCH($B$2,Sheet2!$A:$A,0))¡C                                                      
´¡¤J =>ª«¥ó=>ÂI°}¹Ï
±N½s¿èÄ椤ªº=EMBED("Paint.Picture","")§ï¦¨=P

TOP

¦^´_ 5# kengo

§Ñ¤F¡A ½Ð·j¯Á§Ú©Òµo¡Pªº©«¤l§Y¥i¡C
ss

TOP

¦^´_ 5# kengo
­è¥Î·j¯Á§ä¤F¤@¤U¡A¦³´X½g¬ÛÃöªº¡C
¯u¬O·PÁ«e½ú¡AÅý§Ú¤S¦h¾Ç¤F¤@¨Ç
¥H¤U¬O¤£¥ÎVBAªº
[­ì³Ð] ¤À¨É - °ÊºAÅã¥Ü¹Ï¤ù(¤£¥ÎVBA)

½Ð°Ý¦³¹Ï¤ù¨ç¼Æ¶Ü?
   
¥H¤U¬O¥ÎVBAªºµ{¦¡

vba´¡¤J¹Ï¤ù°ÝÃD
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 3# sunnyso


¤j¤j±z¦n~

¤è«K§iª¾¥DÃD¬O¤°»ò¶Ü?

¤@«Ê¤@«Ê¬d§Ú©È·|¨Ó¤£¤Î¤F-.-

¥i¥H½Ð¤j¤j¸ò§Ú»¡§A¤§«e¯dªº¤å¬O¤°»ò¥DÃD,§Ú¦A¥h§ä

·PÁÂ!

TOP

¦^´_ 2# huijuang


¦]¬°³o¥÷¤å¥ó¬O«e¦P¨Æ°µªº
§Ú¤]¤£·|¼gµ{¦¡
ÀÉ®×A¦³5-6000µ§¸ê®Æ

ÀÉ®×Bªº¹Ï¤ù¦n¹³¬O¹w¥ý¦³³]©w¦n®æ¦¡
¨S¦³¿é¤Jªº®É­Ô¨S¦³¹Ï¤ù~
¦ý¬O¦³¹Ï¤ùªºªÅ¥Õ®Ø®Ø

¿é¤J¼Æ­Èªº®É­Ô~
¸ê®Æ¤Î¹Ï¤ù·|¤@°_§ó§ï

¦³¨S¦³¥i¥H®M¥Îªº®æ¦¡?
©Î¬O¥i¥H±Ð§Ú¦p¦ó¼gµ{¦¡¶Ü?

·PÁÂ!

TOP

¤£¥Îvba¤]¥i¥H, ½Ðª¦¤å, §Ú¦³¤@Ãþ¦ü©«
ss

TOP

¨Ì¹Ï¤ù¬Ý°_¨Ó¡AÀ³¸Ó¬O¥ÎVBA¼gªºµ{¦¡
¨Ò¦p¡G
Sub pic()
PN = Range("A1")  'Ū¨ú4416
ActiveSheet.Pictures.Insert("c:\temp\" & PN & ".jpg").Select
End Sub

¤£ª¾¹D§Ú·Q±o¹ï¤£¹ï
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD