Dear expert
i have set of data range in master A:H i want split value in a col combination of hypen values to closed workbooks of A,B,C,D,....Etc depends upon list of filenames in col H:H.
like if file name is A.xlsb in H col this code run to particular row to A workbook
For Each cell In Sheets("Master").Range("A2:A200") *need to change master sheet as active workbook
If InStr(cell, "-451414-") Then Sheets("RECK").Cells(65000, "E").End(xlUp).Offset(1).Resize(, 12) = Application.Index(Split(Join(Array(Replace$(Replace$(cell, "-0-", "-000000-"), "-", "|"), "00000000", "000", "MAY-15", "USD", "AMOUNT", cell.Offset(, 3), "NO"), "|"), "|"), Array(1, 3, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12))
Next cell
End With
Find the attachment.
Bookmarks