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

¨Ó·½¸ê®ÆÄæ¦ì¤ñ¹ï«á¡A±N­È¶ñ¨ì¬ÛÀ³ªºsheet­¶­±Äæ¦ì¤º

¨Ó·½¸ê®ÆÄæ¦ì¤ñ¹ï«á¡A±N­È¶ñ¨ì¬ÛÀ³ªºsheet­¶­±Äæ¦ì¤º

Book1.rar (10.37 KB)

½Ð±Ð¦U¦ì¥ý¶i
ªþ¥ó¤¤¡Asource¬°¨C¤é¶×¤Jªº¤å¦rÀɸê®ÆÄæ¦ì
¦]¦b¤º¤å¸Ì©È´y­z¤£²M·¡¡Aªþ¥ó¸Ì­±¦³¸Ô­z¨Ã¼Ð¥Ü¹w´Áµ²ªG
Àµ½Ð¥ý¶i­Ì¡Aµ¹¤©§Ú¤@¨Ç«Øij»P¤èªk

ÁÂÁ¤j®a

¦^´_ 1# chi830


    source¤¤ID¨Ã¨S¦³»P§Aªº½d¨Ò¹ïÀ³
½ÐÀˬd¸ê®Æ½T»{¹ïÀ³±ø¥ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

Book1.rar (10.7 KB)

§Ú¦bexcel¤¤¤S­«·s´y­z¤F¤@¦¸¡A½Ð±z¦A¬Ý¤@¤U¡A¬O§_²M·¡?
¥D­n¬O·Q¹F¨ì»¡¡A¥ý±qID§ä¨ì¸Ó¼g¤J­þ­Ósheet?
ª¾¹D«á¡A¦A¤ñ¹ï²Å¦Xªº¤é´Á»P¯Z§O¡A±N®É¶¡¼g¤J³o­Ósheet¸Ì­±

TOP

¦^´_ 3# chi830
  1. Sub ex()
  2. Set d = CreateObject("Scripting.Dictionary")
  3. Set d1 = CreateObject("Scripting.Dictionary")

  4. With Sheets("index")
  5.    For Each a In .Range(.[B2], .[B2].End(xlDown))
  6.    d(a & "") = a.Offset(, -1).Text
  7.    Next
  8. End With
  9. With Sheets("source")
  10.    For Each a In .Range(.[A2], .[A2].End(xlDown))
  11.     d1(a & "," & a.Offset(, 1) & "," & a.Offset(, 2)) = a.Offset(, 3)
  12. Next
  13. End With
  14. For Each ky In d1.keys
  15. sh = d(Split(ky, ",")(0))
  16. With Sheets(sh)
  17. myid = .[A1]
  18.    For Each a In .Range(.[A3], .[A3].End(xlDown))
  19.      a.Offset(, 1).Resize(, 2) = Array(d1(myid & "," & a & "," & "01"), d1(myid & "," & a & "," & "02"))
  20.    Next
  21. End With
  22. Next
  23. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# chi830
¦pªGsource¬O¤@¤Ñªº¤W¤U¯Z®É¨è¸ê®Æ
  1. Option Explicit
  2. Sub Ex()
  3.     Dim D As Object, E As Variant
  4.     Set D = CreateObject("SCRIPTING.DICTIONARY")
  5.     With Sheets("source")
  6.         For Each E In .Range("A2", .[A2].End(xlDown))
  7.             If D(E.Text) = "" Then
  8.                 D(E.Text) = E(1, 2) & "," & E(1, 4).Text
  9.             Else
  10.                 D(E.Text) = D(E.Text) & "," & E(1, 4).Text
  11.             End If
  12.         Next
  13.     End With
  14.     For Each E In Sheets
  15.         If D(E.Cells(1).Text) <> "" Then
  16.            With E.Cells(E.Rows.Count, 1).End(xlUp).Offset(1)
  17.             .Resize(, 3) = Split(D(E.Cells(1).Text), ",")
  18.            End With
  19.         End If
  20.     Next
  21. End Sub
½Æ»s¥N½X

TOP

ªÅ¥Õ¥X¶Ô¤ë³øªí.rar (540.07 KB)

«D±`·PÁÂHsieh ¥ý¶i »PGBKEE ¥ý¶iªºµªÂÐ

Hsieh¥ý¶i©Òµª¬°§Ú¹w´Áµ²ªG¡A§Ú¸ÕµÛ·Ó¦¹¤èªk­×§ï
¦ý¬O®É¶¡­È¤´¶]¤£¥X¨Ó¡A·Ð½ÐHsieh¤j ¦AÀ°§Ú¤@¤U
¬Ý¬Ý¬O­þ¥X¤F¿ù?
¦³¨Çµ{¦¡½X§ÚÁÙ¨S¤F¸Ñ²M·¡
ÁÂÁ±z¤F

GBKEE ¤jªº¤è¦¡¬°ª½±µ·s¼W¡A¤]¥i¦h¾Ç¤F¤@­Ó¤èªk¡A·PÁ±z

TOP

¦^´_ 6# chi830

¤£ª¾¹D³o¼Ë¹ï¤£¹ï?

    ¥X¶Ô.zip (167.8 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh


    Hsieh ¤j~³o¬O¥i¥Hªº,¦¨¥\¤F,ÁÂÁ³á!!

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD