Data showing who pays a doesnt after manually input receipts [Solved]

ramaemachado 2 Posts Monday January 15, 2018Registration date January 16, 2018 Last seen - Jan 15, 2018 at 11:39 PM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Jan 17, 2018 at 07:17 AM
Hello,


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:

date # name amount paid

jan-1-2018 288478 Ricky $300
jan-2-2018 288479 Monica $300
jan-8-2018 288480 Irene $300
feb-2-2018 288481 max $300
feb-4-2018 288482 Monica $300
feb-4-2018 288483 max $300
feb-15-2018 288484 Ricky $300


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!
See more 

Your reply

5 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 16, 2018 at 07:00 AM
3
Thank you
ramaemachado, Good morning.

Your necessity is a common process for this situation.

I did an example for you to study:
https://www.sendspace.com/file/dyuxmn

Adapt formulas and layout to your reality.

Is that what you want?
I hope it helps
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão

Thank you, Mazzaropi 3

Something to say? Add comment

CCM has helped 1844 users this month

ramaemachado 2 Posts Monday January 15, 2018Registration date January 16, 2018 Last seen - Jan 16, 2018 at 10:24 PM
Wow! thank you soooooo much! Great example easy to replicate. I appreciate it tons!
Respond to Mazzaropi
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 17, 2018 at 05:23 AM
0
Thank you
ramaemachado, Good morning.

I'm very happy to have been able to help you with your task.

Have a nice day!
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Ambucias 52566 Posts Monday February 1, 2010Registration dateModeratorStatus June 20, 2018 Last seen - Jan 17, 2018 at 05:25 AM
Marcílio, you are one of CCM's heroes and admired contributor.
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen > Ambucias 52566 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.

Thanks again for the comments.

Have a great day!
Respond to Mazzaropi