No. Column J represents the start of the tax year (06 Apr 2007) and does
contain some opening balances, which would be easy enough to do a data sort
and copy/paste, but it is the remainder who have no opening balance and whose
first payment is random. For a report that I have set up a Mail-Merge, it
needs to know what their opening balance was at the start of the tax year, or
if there is no opening balance, then what was the value of their first
payment and what date was it made.
I could go through each column and do various data sorts and copy/paste, but
with 671 individuals it could take more time than I'd like.

"JLGWhiz" wrote:

Would the entry in column J not be the first payment for each account? Or
are entries made randomly, or are payments made randomly? I am trying to
visualize why you are needing code to do this task. It seems that it could
be done with a cut an paste or copy and paste action.

The additional information did not help to understand the problem.

"Rayashe" wrote:

J5 to CS674 contains the data that needs to go in Column H and J3 to CS674
contains the date that would need to go into column I so that columns H & I
show how much the first payment was and what date it was made.

"JLGWhiz" wrote:

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.