- ©«¤l
- 47
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-1-14
- ³Ì«áµn¿ý
- 2012-3-10
|
¦^´_ 23# Hsieh
«e½ú±z¦n~
§Ú²{¦b¤S¦^Âk¨ì¥»¥DÃD¤@¶}©lªºµ{¦¡½X¡A
§Ú²{¦b´«¿z¿ï¥X¨S¶ñÅvªÑ²¼ªº³ø¹S²v¡A§Ú±NÀɮפU¸ü¦¨¤@¼Ëªº®æ¦¡¡A
¦ý¶K¤Wµ{¦¡½X°õ¦æ«á¡A¥¦»¡«¬ºA¤£²Å!
½Ð°Ý¬Oþ¸Ì¥X¤F°ÝÃD!?
§Ú¬O¥Î¥H¤Uªºµ{¦¡½X!- Sub ex()
- Dim A As Range, B As Range, B1 As Range, B2 As Range, C As Range, Rng As Range, Rng1 As Range, d As Object
- Set d = CreateObject("Scripting.Dictionary")
- Set sht = Sheets.Add(after:=Sheets(1))
- Application.ScreenUpdating = False
- With Sheet1
- For Each A In .Range(.[A2], .[A65536].End(xlUp))
- mystr = A & "," & Left(A.Offset(, 1), 4)
- d(mystr) = DateValue(Format(A.Offset(, 1), "0000/00/00"))
- Next
- End With
- k = 1: r = 1
- For Each ky In d.keys
- y = Split(ky, ",")(1)
- With Sheets(y)
- Set C = .Columns("A").Find(d(ky))
- Set B = .Rows(1).Find(Split(ky, ",")(0))
- If Not C Is Nothing And Not B Is Nothing Then
- x = Application.Max(3, C.Row - 14)
- Set Rng = .Cells(x, 1).Resize(15, 1)
- Set Rng1 = .Cells(x, B.Column).Resize(15, 1)
- With sht
- Rng.Copy .Cells(r, k)
- Rng1.Copy .Cells(r, k + 1)
- .Cells(r, 3) = y & "¦~²Ä" & B.Column - 1 & "µ§"
- End With
- r = r + 15
- Else
- MsgBox "µL¦¹°£Åv¸ê®Æ"
- End If
- End With
- Next
- Application.ScreenUpdating = True
- End Sub
½Æ»s¥N½X (¦]¬°¸ê®ÆÀɮפӤj¡A©Ò¥H§Ú¥ý§R°£¨ä¥L¤E¦~ªº¸ê®Æ¡A¥u³Ñ2010)
ÁÂÁ±z!^^ |
|