Ms Excel match an amount [Closed]

Report
Posts
1
Registration date
Wednesday November 16, 2016
Status
Member
Last seen
November 16, 2016
-
Posts
14509
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 7, 2021
-
hi,
In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact total of these presented cheqs which is difference from my last day closing bank account balance and current bank balance.

i ,e,

Last day bank balance was Rs.50,000

last day not presented cheqs
1. chq#123456 dated:20-08-16........... Rs.4,001

2. chq#123457 dated:21-08-16........... Rs.5,385

3. chq#123458 dated:25-08-16........... Rs.4,350


Today's bank balance was Rs.59,386.

Difference.....Rs. 9,386. (i need this diff amount automatically mentioned the two cheqs (Sr#.1&2)

Hop you understand my low English :) and solve my problem.

Regards,

Rehan Zai

1 reply

Posts
14509
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
March 7, 2021
4
This is quite simple to do, if you have some experience with VBA. Do you have that experience?
How do you want Excel to display the result?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!