- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 19# idnoidno
[A2]=Range("A2")=Cells(2,1),³o¤TºØ¼gªk³£¥i¥H- Sub caldata()
- Dim myrow As Integer
- Dim mycolumn As Integer
- Dim i As Integer
- Dim j As Integer
- myrow = Worksheets("¤u§@ªí1").Cells(Rows.Count, 1).End(xlUp).Row
- mycolumn = Worksheets("¤u§@ªí1").Cells(1, Columns.Count).End(xlToLeft).Column
- mydate = Worksheets("¤u§@ªí2").Cells(2, 1) & "/" & Worksheets("¤u§@ªí2").Cells(2, 2)
- For i = 2 To myrow
- If mydate = Format(Worksheets("¤u§@ªí1").Cells(i, 1), "yyyy/m") Then
- For j = 4 To mycolumn + 2
- Worksheets("¤u§@ªí2").Cells(1, j) = Left(Worksheets("¤u§@ªí1").Cells(1, j - 2), 2) & "¤é¥§¡¶q"
- Worksheets("¤u§@ªí2").Cells(2, j) = Format(Worksheets("¤u§@ªí1").Cells(i + 1, 1), "yyyy/m/d")
- Next
- End 'µ²§ôµ{§Ç
- End If
- Next
- End Sub
½Æ»s¥N½X |
|