You don't need a macro. If you have your list in column A1 downwards put this
in cell B1:

=IF(A10,A1,0)

and this in C1:

=B1-A1

Copy the formulas down as far as necessary and then change the format of the
cells to the following custom:

#,##0.00;(#,##0.00);-

Sam

"ap19" wrote:

Hello. Any help would be greatly appreicated. I have Debits and Credit values
in the same row, what I would like to do is run a macro that will match them
and extract them to cell to the right. Is this possible?

Thanks