Excel¾«Ó¢ÅàѵÍø

 ÕÒ»ØÃÜÂë
 ×¢²á
Êý¾Ý͸ÊÓ±í40+¸ö³£ÓÃС¼¼ÇÉ£¬ÈÃÄãÒ»´Îѧ»á£¡
Â¥Ö÷: ycb20010823

[Òѽâ¾ö]ΪʲômonthÈ¡ÖµÏàͬ

[¸´ÖÆÁ´½Ó]
 Â¥Ö÷| ·¢±íÓÚ 2012-11-27 22:05 | ÏÔʾȫ²¿Â¥²ã
°®·è°æÖ÷ÄãºÃ£¬Èç¹û¹¤×÷±í£¬Ã»ÓÐ2013-1-1»°£¬¾Í²»ÐÐÁË£¬ÄãÊÔһϣ¡£¡
»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

 Â¥Ö÷| ·¢±íÓÚ 2012-11-27 22:10 | ÏÔʾȫ²¿Â¥²ã
°®·è°æÖ÷ÄãºÃ£¬Äã°Ñ¹¤×÷±íÖÐ2013-1-1 ´æÏÖ½ð136.71ÕâÐÐɾÁË£¬Ôٵ㰴ťµÄ»°£¬12ÔÂÏÂÃæ¾Í²»»á³öÏÖÔ¼ÆÀÛ¼ÆÁË£¡
»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

·¢±íÓÚ 2012-11-27 22:18 | ÏÔʾȫ²¿Â¥²ã    ±¾Â¥Îª×î¼Ñ´ð°¸   
Sub ÇóÔ¼ÆÀÛ¼Æ()
    Dim K%
    K = 5
    Do
        If Month(Cells(K, 1)) <> Month(Cells(K + 1, 1)) Or Cells(K + 1, 2) = "" Then
            Rows(K + 1 & ":" & K + 2).Insert
            Cells(K + 1, 3) = "Ô¼Æ"
            Cells(K + 2, 3) = "ÀÛ¼Æ"
            K = K + 2
        End If
        K = K + 1
    Loop Until Cells(K, 2) = ""
End Sub
»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

 Â¥Ö÷| ·¢±íÓÚ 2012-11-27 22:24 | ÏÔʾȫ²¿Â¥²ã
лл°®·è°æÖ÷µÄÎÞ˽°ïÖú£¬Ö»ÊDzîÁËÄÇôһµãµãcells(k+1,2)=""£¬¾Í³É¹¦ÁË£¬¸ÐлÄãÅóÓÑ£¡£¡£¡
»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

·¢±íÓÚ 2012-11-27 22:35 | ÏÔʾȫ²¿Â¥²ã
ÓÉÓÚÎÒµÄʱ¼äºÍ¾«Á¦Ã»¹æÂÉ£¬ÎÞ·¨±£Ö¤¼°Ê±È¥»Ø¸´ºÍ¹Ø×¢¡£
Èç¹ûÓÐҪ̽ÌÖµÄÎÊÌ⣬»¹ÊÇÔÚÂÛ̳·¢Ìû°É£¡Ð»Ð»
»Ø¸´

ʹÓõÀ¾ß ¾Ù±¨

ÄúÐèÒªµÇ¼ºó²Å¿ÉÒÔ»ØÌû µÇ¼ | ×¢²á

±¾°æ»ý·Ö¹æÔò

СºÚÎÝ|ÊÖ»ú°æ|Archiver|Excel¾«Ó¢Åàѵ ( Ô¥ICP±¸11015029ºÅ )

GMT+8, 2024-5-5 21:55 , Processed in 0.515548 second(s), 13 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

¿ìËٻظ´ ·µ»Ø¶¥²¿ ·µ»ØÁбí