Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have an entire row populate with a link when the data in a cell ca | Excel Worksheet Functions | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
how can I link entire sheets? | Excel Worksheet Functions | |||
how to link an entire worksheet to another | Excel Worksheet Functions | |||
how do i link a word to a colour so everytime i type the word gre. | Excel Discussion (Misc queries) |