Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i want to make like a data base for work. I am a sales consultant at a real
estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You have already answered your question?
In row 1, enter the headings that you want to incorporate in your database, such as Surname(A), Name(B), Street Address(C), Suburb(D), City(E), Country/State(F), Phone(G), E Mail(H), Organization(I), Website(J) and so forth. In Rwo 2 dwon, enter the information as per these headings. Once done, sort the list according to Surname, then Name. You can then find any record by pressin <Ctrl<F, and typing in the info you have, be it the contact's name, surname, company, email or whatever. -- Hth Kassie Kasselman Change xxx to hotmail "dsfasdfsadf" wrote: i want to make like a data base for work. I am a sales consultant at a real estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Basically, as you defined it in your posting:
For example .... A1=First Name B1=Last name C1= First address line D1= Second address line E1=City F1=Zip code / Post Code G1=Country etc Consider home addresses & company addresses, and similarly for telephone numbers. List all the possible customer information you think you want and then organise your table. Consider also how you might want to manipulate the date e.g. sorts, extracts, mailing lists as these will (should!) be reflected in how you format/organise the data. HTH "dsfasdfsadf" wrote: i want to make like a data base for work. I am a sales consultant at a real estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identify Windows Profile | Excel Discussion (Misc queries) | |||
how do i profile a survey? | Excel Worksheet Functions | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
How do I email an Excel worksheet? Do I have to create a profile? | New Users to Excel | |||
Profile effecting Excel | Excel Discussion (Misc queries) |