Simple databse but i dont know how...

[lingga.47]

Hi. i'm new to excel and i'm trying to make a simple database, the database contains lastname, firstname, price, mothly due, and date.

for example:
LASTNAME, FIRSTNAME, PRICE MONTHLY DUE, DATE

Lingga Abdullah PHP 4,000.00 PHP 400.00 2/3/2013
Lingga Anisah PHP 800.00 PHP 200.00 2/4/2013
James John PHP 90,000.00 PHP 8,000.00 2/9/2013
Lingga Abdullah PHP 8,000.00 PHP 8,000.00 2/14/2013
Lingga Abdullah PHP 15,000.00 PHP 8,000.00 2/18/2013
Paul Ellis PHP 7,000.00 PHP 800.00 4/21/2013
Paul Ellis PHP 400.00 PHP 200.00 5/23/2013
Paul Ellis PHP 4,000.00 PHP 400.00 2/3/2013
James John PHP 800.00 PHP 200.00 2/4/2013
Lingga Abdullah PHP 90,000.00 PHP 8,000.00 2/9/2013
Lingga Anisah PHP 7,000.00 PHP 800.00 4/21/2013

this data must be in the sheet1, then in my sheet2 i want to have search box, where if he search Lingga Abdullah, all data of Lingga Abdullah will be
displayed in a table in sheet2, for example:

Lingga Abdullah PHP 4,000.00 PHP 400.00 2/3/2013
Lingga Abdullah PHP 90,000.00 PHP 8,000.00 2/9/2013
Lingga Abdullah PHP 8,000.00 PHP 8,000.00 2/14/2013
Lingga Abdullah PHP 15,000.00 PHP 8,000.00 2/18/2013

then total the monthly due and display it below the last data in monthly due...

i know this is much but i dont know how to start, please help, i tried youtube and google but i still dont get it...
thanks in advance...

[ag273n]

dude! were from the same country... if you'd post your data in an excel file (like what you have above) then i'd be glad to create it for you... =)

[ag273n]

I think what you need is a pivot table...
and reference it on the entire columns involved, thus if new data is added, then it'll reflect on the pivot table..
the pivot table will show a summary of the clients, including the sum, given that its a summary, then you wont need a searchbox, ctrl+f will work..

[lingga.47]

sorry. this is my sample excel file...SAMPLE.xlsx
Thank you...

[rcm]

could you upload a sample in excel?

[lingga.47]

i'll try the pivot table, thanks again..

[lingga.47]

Yes this is my sample file, thanks for reply....SAMPLE.xlsx

[arlu1201]

lingga,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

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.