Hi Kenya,
A formula cannot change the value of another cell. All that a
formula can do is return a value.

So you will have to redefine your requirements. From what you wrote
I can't guess at what you are looking for. You could copy the sheet
(possibly in a macro) and sort the words on that sheet. If you know
what the words are you could use COUNTIF to get a count of the
number of occurrences.

Usually you have to think in terms of receiving a value instead of
sending a value. But from what I see of your question it doesn't
look like you can turn it around though that could just be because
there is no information on what you really want to do.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kenya" wrote in message ...
I am trying to create a worsheet that is linked to another(I know how to
link) but I am having difficulties as I can only link to set cells. i am
looking for a formula that will recognise the word and send it to the
specific spreed sheet.For example I have 435 items in one column but instead
of putting the items in selected cells I want the formula to pick up on the
word (THAT HAS BEEN RANDOMLY LISTED IN THE COLUMN) and sends it to the
specified sheet? I hope that does not sound confusing and someone can help
me.Thank you
--
Kenya