View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Link an Entire Row with a Key Word Link an Entire Row with a Key Word is offline
external usenet poster
 
Posts: 1
Default Link an entire Row with a Key Word

I have an excel document that has thousands of rows, but only 3 columns. I
need to know how to link over the whole row of data if a single word is used
in any of the colums. Is this possible?

Here is an example if this was my spreadsheet:

Date Color Flower
3/21 Pink Rose
3/22 White Daisy
3/22 Yellow Rose

And the list goes on and on. But everytime the word 'Rose' is used, I need
the entire row to be linked to another worksheet. Is there a way to do this
without having to manually copy & paste it everytime?