EXCEL²Å¦X±ø¥óÀx¦s®æ¤U¤è´¡¤J¤@¦C
- ©«¤l
- 97
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 158
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2010-9-12
- ³Ì«áµn¿ý
- 2019-8-29
|
EXCEL²Å¦X±ø¥óÀx¦s®æ¤U¤è´¡¤J¤@¦C
¦U¦ì¤j¤j¦n¤p§Ì§Ú¦³¤@Óexcel°ÝÃD¤£ª¾¦p¦ó³B¸Ì½Ð±Ð¤@¤U
po n01234 po#5678
zxcv 1
zxcv 24
zxcv 31
po n01234 po#5678
zxcv 21
zxcv 21
zxcv 3
po n01234 po#5678
zxcv 12
zxcv 2
zxcv 3
·Qn±N¦oÂà´«¦¨
po n01234
po#5678
zxcv
zxcv
zxcv
po n01234
po#5678
zxcv
zxcv
zxcv
po n01234
po#5678
zxcv
zxcv
zxcv
½Ð±Ð§Ún¦p¦ó³B¸Ì§Ú¸Õ¤F«Ü¦h¤èªk¬Ò¤£¯à¹F¨ìn¨D |
|
lionliu
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# lionliu
²Å¦X±ø¥óÀx¦s®æ¤U¤è´¡¤J¤@¦C
±ø¥ó ¬O¤°»ò?
|
|
|
|
|
|
|
- ©«¤l
- 97
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 158
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2010-9-12
- ³Ì«áµn¿ý
- 2019-8-29
|
¥»©«³Ì«á¥Ñ lionliu ©ó 2012-3-23 11:47 ½s¿è
·PÁÂregister313ªº«ü¾É°Õ
§Aªº¤èªk§Ú²{¦b´ú¸Õ¤¤
¦ý¬O¦³¥i¯à¥Î¦Û°Ê¿z¿ï¨Ó°µ¶Ü
±ø¥ó¦¡ range(a:a).value = "PO**"
¦]¬°§ÚªºpoȤ£©T©w©Ò¥H¤~·|·Q¥H"po**"§@±ø¥ó
Ãþ¦ü³o¼Ëªº§@ªk¶Ü
ÁÂÁ§A |
|
lionliu
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 3# lionliu
VBA- Sub FF()
- LastR = [A65536].End(xlUp).Row
- For R = LastR To 1 Step -1
- If Cells(R, 1) Like "po*" Then
- Cells(R + 1, 1).Insert Shift:=xlDown
- Cells(R, 2).Copy Cells(R + 1, 1)
- End If
- Next R
- [B:B] = ""
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 97
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 158
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2010-9-12
- ³Ì«áµn¿ý
- 2019-8-29
|
ÁÂÁÂregister313²Ä¤@ºØ¤èªk¦³°µ¥X¨Ó¤FÁÂÁÂ
¦ý¦]¹³¦¸«Üªø©Ò¥H¤~·|¦³²Ä¤GºØ·Qªk
²{¦b¨Ó¸Õ¤@¤U |
|
lionliu
|
|
|
|
|