Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i set up a customer profile table?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 515
Default how do i set up a customer profile table?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default how do i set up a customer profile table?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify Windows Profile MrAngles Excel Discussion (Misc queries) 1 March 14th 07 10:18 PM
how do i profile a survey? Paul Excel Worksheet Functions 1 September 18th 06 05:54 PM
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET brunod Excel Discussion (Misc queries) 1 July 7th 06 07:01 PM
How do I email an Excel worksheet? Do I have to create a profile? desertmamma New Users to Excel 1 December 30th 05 12:53 PM
Profile effecting Excel Spike Excel Discussion (Misc queries) 2 November 23rd 05 05:18 PM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"