Data showing who pays a doesnt after manually input receipts [Solved]
ramaemachado2
Posts Monday January 15, 2018Registration date
January 16, 2018
Last seen
-
Jan 15, 2018 at 11:39 PM - Latest reply: Mazzaropi1834
Posts Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
- Jan 17, 2018 at 07:17 AM
Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the student, the date and the amount paid. For example:
and so on... manually only entering the name, date and the amont on any random order.
ON sheet 2, i have a table with the name of the student and a full year calendar. Im looking for a way that on January box besides Rickys name, I have $300 or if he did not pay that month, no value. the same for the following months jan-december (1 year) and the same for every other student. Im looking for a simple way of after manually inserting the receipt number with the amount paid, date and name on sheet 1, i can have a full report of all students on a simple JAN-DEC calendar something like this:
JAN FEB MAR APR MAY JUN JULY AGO SEP OCT NOV DEC
RICKY $300 $300
MONICA $300 $300
IRENE $300 $0
MAX $300 $300
I dont need the exact date on the table, only the month they paid.
Was wondering if anyone has a suggestion of how it can be simpler? Any suggestions will be greatly appreciated!
Mazzaropi1834
Posts Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
>
Ambucias52566
Posts Monday February 1, 2010Registration dateModeratorStatus
June 20, 2018
Last seen -Jan 17, 2018 at 07:17 AM
Dear Ambucias, thank you very much for the comments but in fact this is not everything you said.
I have great pleasure in helping people whenever my knowledge reaches the degree of difficulty presented by the question.
Congratulations to you for the good work of moderating this important place of cooperation and international technical assistance in EXCEL.
has helped 1844 users this month