Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Report
Posts
2
Registration date
Monday January 15, 2018
Status
Member
Last seen
January 16, 2018
 -
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 -
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

Answer 1 / 2
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
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
3
Thank you

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

CCM 4422 users have said thank you to us this month

Report
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!
Answer 2 / 2
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
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
Posts
51402
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
April 4, 2020
 14,537
Marcílio, you are one of CCM's heroes and admired contributor.
Report
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135 >
Posts
51402
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
April 4, 2020
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