ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i set up a customer profile table? (https://www.excelbanter.com/excel-discussion-misc-queries/140866-how-do-i-set-up-customer-profile-table.html)

dsfasdfsadf

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

kassie

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


Toppers

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



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com