Please Solve my Problem

Dear Expert(s),

I just need a help from your end. I want to make payment sheet for the employees. I need to include all previous payments with date and cheque number. In detail I really need is,


My Company Name (In Centre) on top


Name of the Person
-----------------------

| S. No. | Date of Payment | Designation | Mode of Payment | Cheque Number | Amount |









--------------
Total Paid
--------------


I need this kind of sheet for each employee of all payments of the whole year that when I click his name out of 200 employee, his all payment history appears with total in the end and I can easily print it out. individually for every person

Please experts, help me to make it in easy way in excel. I have excel 2007.

I am doing job and my boss need this (please help me in simple way that I can understand) to keep my job active.
I really need it in urgency, I am waiting for your kind replies.


Thanks

Muhammed Anwar

1) Pls take a few minutes to read forum rules, because:



Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

2) Then pls upload a sample workbook explaining threre which are your needs.