Sub ポート収容_縦3列化()
m = 30
hostname = Cells(1, 1).Value
For i = 10 To 11
For j = 1 To 3
Cells(m, 2).Value = Cells(i, j).Value
Select Case j
Case 1
Cells(m, 1).Value = "#ポート番号"
portno = Cells(m, 2).Value
Case 2
Cells(m, 1).Value = "#対向機器ホスト"
Case 3
Cells(m, 1).Value = "#対向ポート"
End Select
Cells(m, 3).Value = hostname
Cells(m, 4).Value = portno
m = m + 1
Next j
Next i
End Sub
Sub 機器一覧_縦3列化()
m = 30
For i = 5 To 18
For j = 1 To 7
Cells(m, 2).Value = Cells(i, j).Value
Select Case j
Case 1
Cells(m, 1).Value = "#ホスト名"
hostname = Cells(m, 2).Value
Case 2
Cells(m, 1).Value = "#ホスト呼び名"
Case 3
Cells(m, 1).Value = "#型番"
Case 4
Cells(m, 1).Value = "#設置場所"
Case 5
Cells(m, 1).Value = "#ラック番号"
Case 6
Cells(m, 1).Value = "#マウント位置"
Case 7
Cells(m, 1).Value = "#MGT_IP"
End Select
Cells(m, 3).Value = hostname
m = m + 1
Next j
Next i
End Sub