Sub text1() Dim i, m As Long Dim arr ReDim arr(1 To Range("A1").CurrentRegion.Count) arr = Range("A1").CurrentRegion For i = 1 To UBound(arr) Workbooks.Add ActiveWorkbook.SaveAs "F:\" & arr(i, 1) For m = 1 To 4 Cells(m, 1).Value = arr(i + m - 1, 1) Next i = i + 3 Next End Sub