Ms Excel match an amount

Closed
RehanZai Posts 1 Registration date Wednesday November 16, 2016 Status Member Last seen November 16, 2016 - Nov 16, 2016 at 06:24 AM
yg_be Posts 23342 Registration date Sunday June 8, 2008 Status Contributor Last seen November 21, 2024 - Nov 17, 2016 at 01:28 PM
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
Related:

1 response

yg_be Posts 23342 Registration date Sunday June 8, 2008 Status Contributor Last seen November 21, 2024 5
Nov 17, 2016 at 01:28 PM
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?
0