29063994.xlsx

Credit-list.xlsx

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Split: <br />
-- HainKurt (<a href="https:#a42340004" rel="ugc">https:#a42340004</a>)<br />
-- Rob Henson (<a href="https:#a42340428" rel="ugc">https:#a42340428</a>)<br />
<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
broomee9<br />
Experts-Exchange Cleanup Volunteer
</div>


No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- HainKurt (https:#a42340004 [https:#a42340004])
-- Rob Henson (https:#a42340428 [https:#a42340428])


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
On my main sheet, I have this information of a balance of $1000 dollar that has to be paid . on another sheet I &nbsp;have all his monthly payments where he is to pay of $100 per month to pay the$1000.These payments are entered on this another sheet.How can I link the two sheets so then I can automatically have the figure showing on the first sheet the updated balance.Please explain clearly and give me the best and shortest excel method.
</div>
</div>


On my main sheet, I have this information of a balance of $1000 dollar that has to be paid . on another sheet I  have all his monthly payments where he is to pay of $100 per month to pay the$1000.These payments are entered on this another sheet.How can I link the two sheets so then I can automatically have the figure showing on the first sheet the updated balance.Please explain clearly and give me the best and shortest excel method.

Let say i am a shopkeeper .I sell on a credit .one person owes me $1000 and we agreed that he pays it back on installments of $100 each month .

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.