Worksheet Change Code

Hi all,

I want to use the code below to analyze a spreadsheet and calculat the amounts still outstanding from column R. I have added two columns, AA and AB. If the amount in column R is still outstanding, the user enters N (for not collected) in column AA and the outstanding amount from column R would be copied to column AB. When the spreadsheet is analyzed at a later date and the outstanding amount was collected, the user deletes the N in column AA and the amount in column AB should be deleted also. However, my code is not deleting the amount. Any help?

Please Login or Register  to view this content.

Thank you,
Gos-C

That worked!

Thank you, quekbc.

Cheers,
Gos-C