Forum Discussion
Append portion of even number rows to odd number rows
Below are a few sample rows from an Excel 2019 file, created from a .CSV file. The Excel file contains records of the loan payment transactions for an auto loan. Each payment transaction takes up...
The code dynamically recognizes the number of rows and can handle almost any number of rows. The limit is the maximum number of rows in a worksheet which is 1048576. If you want to visually seperate different loans you can enter the data as shown in the screenshot. The data for one loan is in rows 1 -14 and for the other loan in rows 17 - 34 in the example and the result is returned with an empty row in columns G to L.
For the comparison of actual loan payments with the payment schedule can you attach a screenshot which shows the actual and scheduled data and the layout of the data along with the intended result?
Thanks.
Let me play around with what I've gotten so far, to see what I might want to do next.
Let me play around with what I've gotten so far, to see what I might want to do next.