names ans addresses

[bobbydog]

hi to everyone,
have only just joined, so please treat me as an idiot in terms of you
writings to me

my first question is

i want to make a name and address list in excel 2007
and for each column i want
name first name introd by like dislike
address

now what i want to do is to be able to interlink all the columns s
that by the typing of word like theatre or gardens i can isolat
the others and only to bring up those that like that subject

please remember IDIOT language for me please :laugh:laugh:laugh:laug

 

[Simon Lloyd]

Welcome to To The Code Cage, we hope you will enjoy you
experience here and being part of our community

Bobbydog, didn't i answer a question like this for you on the M
newsgroups?, anyway, post a workbook with your structure and dummy dat
and i can help you directly with that

Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
past the submit button and you will see the Manage Attatchments button
this is where you get to add files for upload, if you have any troubl
please use this link or the one at the bottom of th
any page.

hi to everyone,
have only just joined, so please treat me as an idiot in terms of you
writings to me

my first question is

i want to make a name and address list in excel 2007
and for each column i want
name first name introd by like dislike
addres

now what i want to do is to be able to interlink all the columns s
that by the typing of word like theatre or gardens i can isolate th
others and only to bring up those that like that subject

please remember IDIOT language for me please :laugh:laugh:laugh:laug

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Luke M]

To paraphrase, you want to be able to enter a word, and only see those rows
that contain that word in the like/dislike column (respectively)?

Select the row that contains your headers. Go to Data - Filter ->AutoFilter.
You should now see several little arrows(drop downs). In your like column,
open the drop down, choose custom. Make sure first box is on "contains" and
in the second box, type the word you want to find.

 

[bobbydog]

mrs a mary hants theatre
mrs b jill oxford gardens/theatre
mrs c joan london theatre
mrs d milly london gardens/theatre
x 800 molly bucks trips
x800 x800 trips
hopefully this will upload and thanks for being nic

 

[Gord Dibben]

Across row 1 enter your column titles like Name First Name Address Introd
By Like Dislike

That would be in cells A1 through F1

Now add your data for each person in the cells below these titles.

Then Data>Filter>Autofilter.

Select a column and filter for what you want to see.


Gord Dibben MS Excel MVP

 

[bobbydog]

luke m

you are a star to the power of 10

if i need ought else can i call upon you
many many cheers and have a beer
:
--- Automerged consecutive post before response --
goes for you too gord dibben 5

 

[Luke M]

Thanks bobbydog. I'm on here fairly often and will usually lend a helping
hand/thought if I can, and if not, there's plenty of other knowledgeable
people on here too who can probably help out.

 

[bobbydog]

hi luke
next prob for an excel newbie (total)
if in the left hand column A1 i start to write an address, i
continues in a long horizontal line
and if at any time i want to start a new line then it goes into A2
what i want to do is to put in a full address as it would appear on a
envelope
HO

 

[Gord Dibben]

In one cell?

You could try Formatting to Wrap Text and Autofit Row

Or whenever you want a linefeed in a cell hit Alt + Enter


Gord Dibben MS Excel MVP