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

[µo°Ý] ¦p¦ó§Q¥Îvba°µ¬d¸ß

[µo°Ý] ¦p¦ó§Q¥Îvba°µ¬d¸ß

½Ð°Ý§Ú·Q§Q¥Îvba°µ¬d¸ß
¦ý¬°¦óµLªk¬d¸ß¨ìY:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")¤ºªº­È©O?
¬O­þ¤@­Ó³¡¥÷¼g¿ù¤F.

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Row >= 1 And .Column = 2 Then
  .Offset(0, 3) = Application.VLookup(.Value, "Y:\¼Ú´ð-®w¦s\¶i¥X³f\«È¤H\34CO«È¤H.xls("²Î­p")".[C2:D500], 2, False)
End If
End With
End Sub

¦^´_ 3# rbktwi


    ¬Oªº

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD