Menu
Ask a question Report

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

Posts
2
Registration date
Monday January 15, 2018
Status
Member
Last seen
January 16, 2018
 -
Excel Ask a question Report
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 

2 replies

Best answer
Report
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 130
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

Say "Thank you" 3

A few words of thanks would be greatly appreciated. Add comment

CCM 5744 users have said thank you to us this month

Report
ramaemachado
Posts
2
Registration date
Monday January 15, 2018
Status
Member
Last seen
January 16, 2018
 -
Wow! thank you soooooo much! Great example easy to replicate. I appreciate it tons!
Report
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 130
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
Report
Ambucias
Posts
51373
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
October 29, 2019
 13418 -
Marcílio, you are one of CCM's heroes and admired contributor.
Report
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 130 > Ambucias
Posts
51373
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
October 29, 2019
 -
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!
Ask a question