Segregate Outstanding Payment

[nhims786]

I have the following data in Sheet1 of an Excel Workbook which shows the name of students, the total fees they need to pay for a course, the Ist & IInd installment they have paid (or need to pay) & finally the balance amount pending:


Name Total I Installment II Installment Balance
Aaron 25000 12000 0 13000
Bailey 25000 10000 0 15000
Carl 25000 15000 10000 0
Dale 25000 10000 15000 0

There are different sheets for different courses. Now I want those data in a different sheet where the "Balance" is not equal to zero so that at a glance, I can find out the outstanding payment remaining. How do I go about it? This sheet should have 2 columns - name of the student & the balance amount followed by the total. For e.g. with respect to the above data, the sheet should look like this:


Name Balance
Aaron 13000
Bailey 15000
Total 28000

Thanks

 

[GS]

I use a cumulative column for installments, where the amounts are
entered formula-style (ie: =15000+10000) so I only have to calc
'Balance' as follows...

=TuitionFee-Installments

...where 'Total' and 'Installments' are column-absolute, row-relative
local-scope defined names...

Name: 'Sheet1'!TuitionFee
RefersTo: =$B1

Name: 'Sheet1'!Installments
RefersTo: =$C1

...created while the active cell is in row 1.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion