Link an entire Row with a Key Word
in [Functions]
|
Prev: How can I lookup 2 values in order to return 1?
Next: How do I validate / verify the output from a spline curve
From: Link an Entire Row with a Key Word Link an Entire Row with a Key on 23 Mar 2010 10:29 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?
From: Fred Smith on 23 Mar 2010 11:28
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 Word(a)discussions.microsoft.com> wrote in message news:C2D02ACE-E84C-436A-9E7D-E45557A5213C(a)microsoft.com... >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? |