EXCELæ¬èº«å°±å ·å¤äºå¾å¼ºå¤§çæ°æ®å¤çè½å以åå¾è¡¨çæåè½ãå¯ä»¥åºç¨äºåè¡åä¸çæ°æ®è¡¨å¤çï¼åå ä¸VBAåå°±å¦è添翼ï¼å¯ä»¥è¯å®å°è¯´ä¸ä¸ªä¼ä¸è§æ¨¡å¨100人以ä¸çæææ°æ®å¤ççä¸å¡ï¼ä¸å å«ä¸ä¸ç设计èç´ï¼å¦CADç»å¾ï¼ï¼EXCELé½å¯ä»¥å®æã
EXCELçå®ï¼åªè¦æ¯ç¬¦åé»è¾çè¦æ±é½å¯ä»¥è¾¾å°ã
ç»ä¸æ®µä»£ç ä¾åèãè¿ä¸ªç¨åºæ¯ä¸ä¸ªä¾å¥¶ç«çåºç¨ä¸çä¸ä¸ªåè½ï¼è´è´£æ ¹æ®è®¢å¥¶è®°å½çè¦æ±ï¼æ¯å¤©èªå¨çæé奶记å½ã
代ç å¦ä¸ï¼
Sub èªå¨æ·»å é奶记å½()
Call 计ç®å·²éæ°é 'å¨æ·»å é奶记å½åå 计ç®å·²éæ°éï¼é²æ¢å·²ç»éå®ç继ç»äº§çé奶记å½
Dim mYs1, mYs2 As String
Const mYmax = 100 '订奶记å½æ大æ°
Dim mYarr1(1 To mYmax, 1 To 10)
Dim I, J, K, L As Integer
Dim mYday As Date
Dim mYweek As Integer
Sheets("管çå·¥å ·").Select
mYday = Cells(5, 5)
mYweek = Cells(5, 6) 'å¨1~å¨æ¥ 1~6
mYs1 = "订奶记å½"
mYs2 = "å½å¤©é奶记å½"
Sheets(mYs1).Select
I = 2
Do While Len(Cells(I, 1)) > 0
If Cells(I, 7) < Cells(I, 6) And Cells(I, 8) <= mYday Then
'å°å·²éæ°éå°äºè®¢è´§æ°é ä¸ èµ·éæ¥æå°äºå½å¤©æ¥æ
For J = 1 To 10
mYarr1(I - 1, J) = Cells(I, J)
Next J
End If
I = I + 1
Loop
I = I - 2 'Iè®°å½äºç¬¦åé奶æ¡ä»¶çè®°å½æ°
'çæé奶记å½
'step1ï¼å°å½å¤©é奶记å½æ¸ é¤
Sheets(mYs2).Select
Range("A2:F1000").Clear
J = 2 'è®°å½å½åè¡å·
For K = 1 To I
If mYarr1(K, 9) = "æ¯å¤©" Or (mYarr1(K, 9) = "å¹³æ¥" And mYweek <> 6 And mYweek <> 7) Then
Cells(J, 1) = mYday
Cells(J, 2) = mYarr1(K, 1)
Cells(J, 3) = mYarr1(K, 3)
Cells(J, 4) = mYarr1(K, 4)
Cells(J, 5) = mYarr1(K, 5)
Cells(J, 6) = mYarr1(K, 10)
J = J + 1
End If
Next K
Sheets("管çå·¥å ·").Select
End Sub
订奶记å½è¡¨æ ¼å¦ä¸æ示ï¼
æ ¹æ®ä¸é¢ç订奶记å½ï¼èªå¨çæä¸é¢çé奶记å½ã