¿¬½ÀÀå(´Ù¹ö¸®°í °©´Ï´Ù...)-³²±æ ±ÛÀÌ ÀÖÀ¸¸é ¹Î°¡ÃÌ¿¡ ³²°ÜÁֽðí, ȸ¿ø °¡ÀÔÀ» ¹ÞÁö ¾Ê½À´Ï´Ù. |
---|
2016/02/12 (17:02) from 124.137.60.57' of 0' | Article Number : 1084 |
... | Access : 827 , Lines : 149 |
¿¢¼¿ ¸ÅÅ©·Î_µ¥ÀÌŸ Á¤·Ä |
---|
Download : 20160212_µ¥ÀÌÅÍ»ùÇøµ.xlsm
(1106 Kbytes)
|
-. ºô¸µLog ±¸¼º | ±¸¸Å¹øÈ£ | ¾ÆÀ̵ð | ¾ÆÀÌÅÛ¹øÈ£ | ±¸¸ÅÀÏÀÚ | ±¸¸ÅÃÑ±Ý¾× | ¸®¾óij½Ã | º¸³Ê½ºÄ³½Ã | °ÔÀÓij½Ã | CORRELATION(item_id) | | 479789 | cucu005 | 476 | 2015-12-21 22:27:55.913 | 990 | 990 | 0 | 0 | -8755099012208406048 | | 479788 | cucu005 | 476 | 2015-12-21 22:27:46.650 | 990 | 990 | 0 | 0 | -8755099012217925424 | -. À¯·á¾ÆÀÌÅÛ °ü·Ã Log Á¤·Ä / ¹ß»ý ½Ã°£ ¼øÀ¸·Î ±â·ÏÀÌ µÇ¾î Àֱ⠶§¹®¿¡, À¯·á ¾ÆÀÌÅÛº° ±â·Ï È®ÀÎÀÌ ¾î·Á¿ò / Item_id ±âÁØÀ¸·Î µ¥ÀÌŸ ÀçÁ¤·Ä, Âü°í·Î ±¸¸Å¹øÈ£¸¦ »ç¿ë Dim sPost(nMaxList, 2) As String -. CORRELATION(item_id) ±âÁØÀ¸·Î µ¥ÀÌŸ ±³È¯, Á¤¸® / Ž»ö ¹üÀ§¸¦ ÁÙÀÌ´Â ¹æ¹ý °í¾È -. º¯¼öÇü ŸÀÔ¿¡ µû¶ó Å©±â°¡ Àֱ⠶§¹®¿¡ ´ë¿ë·® µ¥ÀÌŸ 󸮽à ÁÖÀÇ '//============================================================================= '//============================================================================= Sub reset() Const nMaxList As Long = 14000 Dim sPost(nMaxList, 2) As String Dim sBuy_ID As String Dim nCounter As Long Application.ScreenUpdating = False 'ÄÚµå ½ÇÇà Áß Â÷Æ®¿Í °°Àº È¸é ¾÷µ¥ÀÌÆ® ¹æÁö Application.Calculation = xlCalculationManual 'ÄÚµå ½ÇÇà Áß ¼¿ °è»ê ¹æÁö Application.EnableEvents = False 'À̺¥Æ® ½ÇÇà ¹æÁö '//============================================================================= Sheets("ºô¸µLog").Select nCounter = 0 For i = 2 To nMaxList Cells(i, 1).Select sBuy_ID = ActiveCell ' ±¸¸Å¹øÈ£ If (sBuy_ID = "") Then Exit For sPost(nCounter, 0) = sBuy_ID ' ±¸¸Å¹øÈ£ sPost(nCounter, 1) = ActiveCell.Offset(0, 8).Value ' CORRELATION nCounter = nCounter + 1 Next i '//----------------------------------------------------------------------------- '//----------------------------------------------------------------------------- Const nListStart As Long = 6 'Const nMaxListSearch As Long = 10000 Dim nMaxListSearch As Long Dim nListCurrent As Long Dim nListSearch As Long nMaxListSearch = nListStart nListCurrent = nListStart nListSearch = nListStart '//----------------------------------------------------------------------------- Sheets("¿øÀå").Select Range("a1:n2").Select Selection.ClearContents Cells(1, 3).Select ActiveCell.Value = nCounter Do While (Cells(nMaxListSearch, 2) <> "") nMaxListSearch = nMaxListSearch + 1 Loop Cells(1, 7).Value = nMaxListSearch '//----------------------------------------------------------------------------- nListCurrent = nListStart For i = 0 To nCounter If (nListSearch = nMaxListSearch) Then Exit For If (sPost(i, 1) <> "") Then Cells(1, 4).Value = i Cells(1, 5).Value = nListSearch For j = nListSearch To nMaxListSearch Cells(1, 6).Value = j If (Cells(j, 2) = "") Then Exit For If (sPost(i, 1) = Cells(j, 12)) Then If (j = nListSearch) Then nListCurrent = nListCurrent + 1 nListSearch = nListCurrent Else Cells(j, 11).Value = sPost(i, 0) Cells(nListCurrent, 1).Resize(1).EntireRow.Insert Cells(j + 1, 1).Resize(1, 20).Copy Cells(nListCurrent, 1).Resize(1, 20) Cells(j + 1, 1).Resize(1).EntireRow.Delete nListCurrent = nListCurrent + 1 End If End If Next j nListSearch = nListCurrent End If Next i '//----------------------------------------------------------------------------- ' Áߺ¹ µ¥ÀÌÅÍ »èÁ¦ ' ´ÜÀ§ °Ë»ö ¹üÀ§ ; ±¸¸Å¹øÈ£ Cells(nListCurrent, 11) nListCurrent = nListStart nListSearch = nListCurrent + 1 Do While (Cells(nListCurrent, 11) <> "") If (Cells(nListSearch, 11) = "") Then Exit Do Cells(2, 5).Value = nListCurrent Do While (Cells(nListSearch, 11).Value = Cells(nListCurrent, 11).Value) nListSearch = nListSearch + 1 Loop For i = nListCurrent To (nListSearch - 1) For j = (i + 1) To nListSearch If ((Cells(i, 3) = Cells(j, 3)) And (Cells(i, 14) = Cells(j, 14))) Then Cells(2, 6).Value = j Cells(j, 1).Resize(1).EntireRow.Delete End If Next j Next i ' ´ÙÀ½ ´Ü°è·Î À̵¿ If (nListSearch = nListCurrent) Then nListSearch = nListCurrent + 1 nListCurrent = nListSearch nListSearch = nListCurrent + 1 Loop Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub |