Snasui Excel Forum

Hi dear,
when i enter the customer name in column "C" then the last balance of that customer should be display in column "G",
there are 5 sheets,
customer sheet ( opening Balance )
item entry sheet (item wise bill)
Bill entry sheet (bill wise total)
sale return sheet
Receipt sheet,

(opening balance+new bill-receipt-sale return) = result ?

thanks

see attachment

sna wrote: Fri Oct 14, 2022 1:19 pm there are 5 sheets,

I found 4 sheets and named of each sheet difference from your post above.

Hi Dear

Please cancelled this,my co worker,send wrong file I didn't check too .
So sorry.when got his right file.will update in new thread.

Thanks.

Closed this thread as well.