質問編集履歴
1
コードの修正をしました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -9,37 +9,43 @@
|
|
|
9
9
|
下記、途中まで組んでいたマクロですが、訳が分からなくなりました。
|
|
10
10
|
ご教示いただけますと幸いです。宜しくお願い致します。
|
|
11
11
|
|
|
12
|
+
```ここに言語を入力
|
|
12
|
-
Sub
|
|
13
|
+
Sub 連絡表シートに入力した情報である種類と時間を勤怠シートに転記する()
|
|
13
14
|
|
|
14
|
-
Dim Renrakuhyou As Worksheet
|
|
15
|
+
Dim Renrakuhyou As Worksheet
|
|
15
|
-
Dim
|
|
16
|
+
Dim Kintaideta As Worksheet
|
|
16
|
-
Dim MyList() As Variant
|
|
17
|
+
Dim MyList() As Variant
|
|
17
|
-
Dim LastRow As Long
|
|
18
|
+
Dim LastRow As Long
|
|
18
|
-
Dim i As Long
|
|
19
|
+
Dim i As Long
|
|
19
|
-
Dim j As Long
|
|
20
|
+
Dim j As Long
|
|
20
|
-
Dim Cnt As Long
|
|
21
|
+
Dim Cnt As Long
|
|
21
22
|
|
|
22
|
-
Set Renrakuhyou =
|
|
23
|
+
Set Renrakuhyou = Worksheets("連絡表")
|
|
23
|
-
Set
|
|
24
|
+
Set Kintaideta = Worksheets("勤怠データ")
|
|
24
25
|
|
|
25
26
|
Renrakuhyou.Select
|
|
26
|
-
|
|
27
|
+
|
|
27
28
|
'連絡表シートの値を配列へ格納
|
|
28
|
-
MyList = Renrakuhyou.Range(Cells(4, 4), Cells(Cells(Rows.Count, 4).End(xlUp).Row,
|
|
29
|
+
MyList = Renrakuhyou.Range(Cells(4, 4), Cells(Cells(Rows.Count, 4).End(xlUp).Row, 5))
|
|
29
30
|
|
|
30
31
|
'勤怠データシート 最終行
|
|
31
|
-
LastRow =
|
|
32
|
+
LastRow = Kintaideta.Cells(Rows.Count, 4).End(xlUp).Row
|
|
32
33
|
|
|
33
|
-
'
|
|
34
|
+
'連絡表シート 最終行までループ
|
|
34
35
|
For i = 2 To LastRow
|
|
35
36
|
|
|
36
|
-
|
|
37
|
+
Cnt = 0
|
|
37
38
|
|
|
38
|
-
|
|
39
|
+
'配列ループ
|
|
39
|
-
|
|
40
|
+
For j = 2 To UBound(MyList)
|
|
40
41
|
|
|
41
|
-
|
|
42
|
+
'日づけが一致したら
|
|
42
|
-
|
|
43
|
+
If Renrakuhyou.Cells(i, 7) = MyList(j, 1) Then
|
|
44
|
+
|
|
45
|
+
End If
|
|
46
|
+
|
|
47
|
+
Next j
|
|
48
|
+
Next i
|
|
43
49
|
|
|
44
50
|
End Sub
|
|
45
|
-
|
|
51
|
+
```
|