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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link an entire Row with a Key Word
It's not clear what you mean by "linked", but one option is to use Data
Filter. Filter the "Rose" rows, the copy the visible cells. Regards, Fred "Link an Entire Row with a Key Word" <Link an Entire Row with a Key wrote in message ... 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? |
Reply |
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) |