If your question is how to fill columns H and I via code, then you would have
to furnish some information about where to find the data to put in those
columns, or how it can be calculated from the data in row 3 and payments
entered in the other rows. Otherwise, I would say to just type it in as you
go since there is no way for us to know what those first payment dates and
amounts are from the original posting.

"Rayashe" wrote:

Columns A to G contain client data such as name etc.
Columns J to CS contain payments.
Row 3 in each of the above columns contain the payment date.
Payments are in Rows 5 to 674

In Column H I need to put in the first payment, and Column I needs to have
the date of that first payment.

How can I do this?

Thanks.