Worksheets ("FCL").Cells( 1, 2).Value = Worksheets ("LoanListFCL").Cells( 2, 1,).Value
Worksheets ("FCL").Cells( 1, 4).Value = Worksheets ("LoanListFCL").Cells( 2, 2).Value
Worksheets ("FCL").Cells( 1, 6).Value = Worksheets ("LoanListFCL").Cells( 2, 3).Value
Worksheets ("FCL").Cells( 2, 2).Value = Worksheets ("LoanListFCL").Cells( 2, 4).Value
Worksheets ("FCL").Cells( 2, 4).Value = Worksheets ("LoanListFCL").Cells( 2, 5).Value
Worksheets ("FCL").Cells( 5, 5).Value = Worksheets ("LoanListFCL").Cells( 2, 6).Value
Worksheets ("FCL").Cells( 5, 2).Value = Worksheets ("LoanListFCL").Cells( 2, 8).Value
Worksheets ("FCL").Cells( 5, 3).Value = Worksheets ("LoanListFCL").Cells( 2, 9).Value
Worksheets ("FCL").Cells( 5, 4).Value = Worksheets ("LoanListFCL").Cells( 2, 10).Value
Worksheets ("FCL").Cells( 5, 6).Value = Worksheets ("LoanListFCL").Cells( 2, 11).Value
Worksheets ("FCL").Cells( 13, 2).Value = Worksheets ("LoanListFCL").Cells( 3, 1).Value
Worksheets ("FCL").Cells( 13, 4).Value = Worksheets ("LoanListFCL").Cells( 3, 2).Value
Worksheets ("FCL").Cells( 13, 6).Value = Worksheets ("LoanListFCL").Cells( 3, 3).Value
Worksheets ("FCL").Cells( 14, 2).Value = Worksheets ("LoanListFCL").Cells( 3, 4).Value
Worksheets ("FCL").Cells( 14, 4).Value = Worksheets ("LoanListFCL").Cells( 3, 5).Value
Worksheets ("FCL").Cells( 17, 5).Value = Worksheets ("LoanListFCL").Cells( 3, 6).Value
Worksheets ("FCL").Cells( 17, 2).Value = Worksheets ("LoanListFCL").Cells( 3, 8).Value
Worksheets ("FCL").Cells( 17, 3).Value = Worksheets ("LoanListFCL").Cells( 3, 9).Value
Worksheets ("FCL").Cells( 17, 4).Value = Worksheets ("LoanListFCL").Cells( 3, 10).Value
Worksheets ("FCL").Cells( 17, 6).Value = Worksheets ("LoanListFCL").Cells( 3, 11).Value
What i am trying to do is be able to put as many lines as possible in LoanListFCL and have it populate over to FCL without having to write this code over and over changing the cell numbers. Also, after about 40 or so it errors out because the code is just too long. Any help is much appreciated.
Bookmarks