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

[µo°Ý] ¸Uµ§¸ê®Æ§Ö³t¤ñ¹ï³B²z

[µo°Ý] ¸Uµ§¸ê®Æ§Ö³t¤ñ¹ï³B²z

¥»©«³Ì«á¥Ñ bioleon69 ©ó 2017-10-9 23:11 ½s¿è

¤u§@ªí¤@
¬ù¦³¨â¸Uµ§¸ê®Æ
1.JPG
2017-10-9 23:06

¤u§@ªí¤G
¬ù¦³250µ§¸ê®Æ
2.JPG
2017-10-9 23:06


·Q±q¤u§@ªí¤@¥u¯d¤U»P¤u§@ªí2²Å¦XªºªÑ²¼¥N¸¹
¤£²Å¦Xªºrows¥þ³¡§R°£±¼

³Ì«á¯d¤Uªº¸ê®Æ·|¥u³Ñ¤U¸ò¤u§@ªí2¤@¼Ë(¬ù250µ§)
¦Ó¤£¬O¨â¸Uµ§¸ê®Æ...

½Ð°Ý¤j¤j­Ì
³o¼Ë±¡ªp
À³¸Ó±o«ç»ò³B²z·|¤ñ¸û§Ö³t
ÁٽЦU¦ì¤j¤j«ü¾É§Þ¥©
ÁÂÁÂ!

¯¬¦U¦ì¤¤¬î´r§Ö!


ªþ¤W excelÀÉ
test1.rar (795.97 KB)
VBA ±q0¶}©l
¥ý±q¾Ç·|¬ÝªºÀ´¶}©l
¥ý±q·|¦³°ò¥»­×§ï¯à¤O¶}©l
¤@¨B¤@¨B¾Ç²ß¤¤

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-10-10 02:59 ½s¿è

¦^´_ 1# bioleon69
VLOOKUP.rar (349.65 KB)

Sheet1!B1
=IF($A1="","",VLOOKUP($A1,Sheet1!$B:$H,COLUMN(),))
¥k©Ô¦ÜGÄæ¡A¦b¥k¤U¨¤ªº¤p"+"§Ö³tÂI2¦¸¡A©Î¤U©Ô¶ñº¡¡C

Sheet2!B:G¦³«Ü¦hÅã¥Ü#N/AªºÀx¦s®æ¡A
Sheet2! AÄ檺¬Y¨Ç¥N¸¹¡A¬O¤£¬OSheet1!BÄæ¨S¦³¡H
Sheet1!¤Ó¦hµ§¡A¨S¥J²Ó¬Ý¡C

TOP

¦^´_ 1# bioleon69
VLOOKUP_vba.rar (355.73 KB)

¤£¦n·N«ä¡A¨Sª`·N¨ì°ÝÃD¬O©ñ¦bµ{¦¡°Ï
¦A¸É¤Wµ{¦¡½X

Private Sub CommandButton1_Click()
[B1:G500] = ""

[B1].Resize(500, 6) = "=IF($A1="""","""",VLOOKUP($A1,Sheet1!$B:$H,COLUMN(),))"
[B1].Resize(500, 6) = [B1].Resize(500, 6).Value

[H1].Select
End Sub

TOP

¦^´_ 3# ziv976688


ZIV~ÁÂÁ§Aªº¦^ÂÐ!
¦pªG¬O»¡
­n§âSHEET1¦h¾lªº¤£²Å¦XªÑ²¼¥N¸¹
¥þ³¡§R°£À³¸Ó«ç»ò°µ¤ñ¸û¦n?!
VBA ±q0¶}©l
¥ý±q¾Ç·|¬ÝªºÀ´¶}©l
¥ý±q·|¦³°ò¥»­×§ï¯à¤O¶}©l
¤@¨B¤@¨B¾Ç²ß¤¤

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2017-10-10 19:11 ½s¿è

¦^´_ 4# bioleon69
Sheet1=¸ê®Æ®w¡ASheet2­n¤ñ¹ïªºAÄæ¸ê®Æ¤@¯ë³£À³¸Ó¬O¥H¤â°Ê¤è¦¡¶ñ¤Jªº¡A¦]¦¹¡A¬O¤£¬O¥ý±NSheet2!A¤£­n¤ñ¹ïªº¦C¡A¥ý¦Û¦æ²¾°£«á¦A°õ¦æ¥¨¶°¡C

©Î¦b²Ä¤@¦¸°õ¦æ¥¨¶°«á¡A±NSheet2¦³Åã¥Ü#N/Aªº¦C²¾°£(µ§¼Æ¤£¦h¡A¥B¥u­n²¾°£¤@¦¸¡AÀ³¸Ó¤£·|«Ü³Â·Ð)¡A¦A°õ¦æ¥¨¶°¤@¦¸§Y¥i¡C

§Ú¤£À´ªÑ²¼¡A¤£ª¾¨ä¥N¸¹¦³¨S¦³¯S©wªº«¬ºA?¦³ªº¸Ü¡A¥i¥H¥Î"¨ú¥N"©Îµ{¦¡²¾°£«D«ü©w«¬ºAªºSheet1ªº¦C
¥H¤W¶È¨Ñ°Ñ¦Ò

TOP

¦^´_ 1# bioleon69
¨Ì§A¿z¿ï³W«h¡A±q1¸U9¤d¦hµ§¸ê®Æ¤¤Á`¦@·|¿z¥X272µ§¸ê®Æ¡A»P»Ý¤ñ¹ïªº249µ§¸ê®Æ¦h¥X23µ§¡A¸gÀˬd¸ê®Æ®w«áµo²{¦@¦³33µ§ªÑ²¼¥N¸¹·|¦³¨âºØªÑ²¼¦WºÙ¡A¨Ò¦p¡G
61071¥]§t¡G·L¬P°ê²¼71ÁÊ01¡BµØ¬ü¤@¡A¨âºØªÑ²¼¦WºÙ
61262¥]§t¡Gºa¦¨¤¸¤j6CÁÊ01¡B«H­µ¤G¡A¨âºØªÑ²¼¦WºÙ
61274¥]§t¡G¿³¶Ô¥ÃÂ×6CÁÊ01¡B¤E»¨¥|¡A¨âºØªÑ²¼¦WºÙ
...±ÚÁc¤£¤Î³Æ¸ü¡C

¥t¥~»Ý¤ñ¹ïªº249µ§¸ê®Æ¤¤¡A¨S³Q¿z¥XªºªÑ²¼¥N¸¹¦@¦³©³¤Uªº10µ§¡G
13361¡B14663¡B17152¡B24022¡B30181¡B30392¡B35352¡B47143¡B80381¡B81712

TOP

test1.rar (784.03 KB)
sheets(1)ªº«ö¶s¥i¥H§¹¦¨§Aªº§@·~
lmh

TOP

¦^´_ 1# bioleon69

¶i¶¥¿z¿ï

   
play.gif
2017-10-11 10:55
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ bioleon69 ©ó 2017-10-11 21:21 ½s¿è

¦^´_ 8# Hsieh

ÁÂÁÂ
ziv976688
Kubi
mhl9mhl9
Hsieh
ªº«ü¾É¤èªk

ziv976688
ÁÂÁ±zªº«ü¾É,§Ú¤F¸Ñ·N«ä¤F
¦]¬°§Ú¥D­n¬O·Q§â¤u§@ªí1ªº¼Æ¾Ú¯d¤U»Ý­n¬Ý±o¦Ó¤w
¨â¸Uµ§¥e¤F¤Ó¦h®e¶q..
¥Ø«e¬O¦b¥[°j°é§PÂ_§âNAªº¥þ³¡§R°£«á
¤u§@ªí2¸ê®Æ½Æ»s°_¨Ó
¦A¸õ¨ì¤u§@ªí1,§â¨â¸Uµ§§R°£
µM«á¦A±N¤ñ¹ï«áªºVALUE­È¶K¨ì¤u§@ªí1
³o¬O¥Ø«e¤p§Ìªº·ÓµÛ±zªº»¡©úºtÅܪº¸Ñ¨M¤èªk ·PÁ·PÁÂ


KUBI
·PÁ´£¿ô,§Úª¾¹D­ì¦]¬O¤°»ò¤F «¢
¤u§@ªí2ªº¼Æ¾Ú¤@­Ó¤ë¤~·|¤½¥¬¤@¦¸
¤u§@ªí1ªº¬O¨C©P,¤¤¶¡¹j¤F¤T©P¨S§ó·s
¸ê®Æ¦³²§°Ê

mhl9mhl9
·PÁ±zªº«ü¾É
¤£¹L¤p§Ìªºµ{«×¦ü¥GÁÙ¤£¤Ó°÷
¦AºCºC§l¦¬¤¤...
«¢ µ{¦¡½Xµy·L°ª²`¤FÂI©Ô!!
¤£¹L³o­Ó¦r¨åªº¥\¯à³t«×­Ë¬O®¼§Ö!!
(PS,¤£¬O§@·~©Ô!..¤p§Ì¦Û¤v¨C©P°lÂܪѲ¼¥Îªº..¦Û¥Î..¦Û¥Î)

Hsieh
·PÁª©¤j...³o°ÊºA¹Ï¤ù¯u°÷¤ûB
¥Ø«e·ÓµÛ¿ý»s«á(µ{¦¡½X¥u¦³¨â¦æ!)
¦Û¦æ¿ý»s«á>§R°£¤u§@ªí1ªº2¸Uµ§¸ê®Æ
¦A±N¶i¶¥¿z¿ï«áªº¸ê®Æ¶K¨ì¤u§@ªí1

¥Ø«e¨â­Ó¤ñ¹ï¤èªk¤J¤â ·PÁ·PÁ¦U¦ì¤j¤j!!
VBA ±q0¶}©l
¥ý±q¾Ç·|¬ÝªºÀ´¶}©l
¥ý±q·|¦³°ò¥»­×§ï¯à¤O¶}©l
¤@¨B¤@¨B¾Ç²ß¤¤

TOP

¦^´_ 1# bioleon69
sheet1ªº20000µ§¸ê®Æ¸Ë¶id,sheet2ªº500µ§¸ê®Æ¸Ë¶idd,¤Z¬Od¨½¦³ddªº½s¸¹ªº¸ê®Æ¸Ë¶iddd,³Ì«á§R°£sheet1ªºÂ¸ê®Æ¶K¤Wddd,´N¬O©Ò»Ýµ²ªG.
¥Ñ©ó¦r¨å°õ¦æ±o«Ü§Ö,¤W­zÅÞ¿è²M·¡,¦pªG¸ê®Æ·½¦³ÅܤƩ岪G­n¨D¦³ÅܤÆ,µ{¦¡½X«Ü®e©ö­×§ï.©Ò¥HÃþ¦ü½ÒÃD§Ú³£³ßÅw¥Î¦r¨å³B²z.
lmh

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD