+ Reply to Thread
Results 1 to 4 of 4

Control of debts and school payments

  1. #1
    Registered User
    Join Date
    06-05-2021
    Location
    santo domingo
    MS-Off Ver
    2019
    Posts
    9

    Control of debts and school payments

    Greetings. I want to control payments and debts in excel for school fees. I have a table where the values ​​are stored when a payment is made and another where the list of students and their schedules are. The table where the data is stored contains the name of the students, the date they paid and the month in question

    What advice could you give me?




    Thanks for your aswers.
    Last edited by antonys; 06-12-2021 at 10:58 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Control of debts and school payments

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-05-2021
    Location
    santo domingo
    MS-Off Ver
    2019
    Posts
    9

    Re: Control of debts and school payments

    The data of the base sheet is obtained from a receipt with macros to save. The data of the student sheet is entered manually
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Control of debts and school payments

    With the exception of cells A2 and D2 on the ESTUDIANTES sheet, I don't see where any of the values shown on the BASE sheet are used.
    Cell A2 could be populated using: =BASE!J2
    Cell D2 could be populated using: =BASE!C2
    I feel that we need more explanation as to how the columns on the ESTUDIANTES sheet should be populated in order to help.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. From-To Matrix to reconcile debts among pairs of people
    By arveearv in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-23-2020, 12:46 PM
  2. Replies: 3
    Last Post: 03-08-2018, 08:24 PM
  3. Calculating interest rate with changing payments and baloon payments
    By weirgr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2017, 04:01 PM
  4. [SOLVED] Loan Payment Schedule with Interest-Only Payments & P & I Payments
    By Masscatz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2014, 11:51 AM
  5. Consolidating Debts for Bills
    By LuckyDay in forum Excel General
    Replies: 2
    Last Post: 09-22-2010, 08:49 AM
  6. [SOLVED] How to create a worksheet to accelerate debts
    By Excel_Challenged in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2005, 03:06 PM
  7. [SOLVED] How do I forecast future payments by analyzing past payments?
    By CeeBee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1