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