- ©«¤l
- 16
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 29
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP PRO
- ³nÅ骩¥»
- EXCEL 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-5-5
- ³Ì«áµn¿ý
- 2014-8-15
|
[µo°Ý] ½Ð¨D ¦Û°Ê¨ÌÄæ¦ì¤ÀÃþ¥¨¶° קï
¥»©«³Ì«á¥Ñ tony0318 ©ó 2010-5-24 14:54 ½s¿è
½Ð°Ý©³¤Uµ{¦¡½X¡Aì¥ý·|¨Ì·Ó²Ä¤@Äæ¦ìªº¤£¦P¦Û°Ê¤ÀÃþ¨ì¦U¤u§@ªí¡A
·Qª¾¹D¦p¦ó¥H²Ä¤TÄæ¦ì§@¬°¤ÀÃþ¡I¦]¬°¹ïµ{¦¡¤£À´¡A¥u¯àTRY¡AÁÂÁ¡C- Sub ex()
- '
- Dim A As Range
- Set d = CreateObject("Scripting.Dictionary")
- With Sheet1
- For Each A In .Range(.[A2], .[A65536].End(xlUp))
- If IsEmpty(d(A & "")) Then
- Set d(A & "") = Union([A1:L1], A.Resize(, 12))
- Else
- Set d(A & "") = Union(d(A & ""), A.Resize(, 12))
- End If
- Next
- For Each ky In d.keys
- With Sheets.Add(after:=Sheets(Sheets.Count))
- .Name = ky
- d(ky).Copy .[A1]
- End With
- Next
- End With
- '
- End Sub
½Æ»s¥N½X §Æ±æ§e²{¦pªþ¥ó ¤ÀÃþ
ZO.rar (11.29 KB)
|
|