Just change that red color 4 to 17 and red color 3 to 5
Please if you agree and satisfied with the solution then click on Add Reputation below to the post left side![]()
FR = 3 FR1 = 4 fin = Array("L", "M", "N", "J", "K") For k = LBound(fin, 1) To UBound(fin, 1) .Range(fin(k) & j).Copy Workbooks("" & mybk & "").Sheets("Financials").Cells(FR1, FR) If FR = 5 Then FR = 3 FR1 = FR1 + 3 Else FR = FR + 1 End If
Bookmarks