Copy text of cell into another tab based on its color

%3CLINGO-SUB%20id%3D%22lingo-sub-2665518%22%20slang%3D%22en-US%22%3ECopy%20text%20of%20cell%20into%20another%20tab%20based%20on%20its%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665518%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20table%20in%20a%20second%20tab%20(2nd%20figure)%2C%20where%20all%20the%20experiment%20numbers%20which%20have%20a%20certain%20color%20(1st%20figure)%2C%20line%20up%20into%20a%20column.%20In%20this%20way%2C%20all%20the%20different%20types%20of%20experiments%20are%20The%20color%20of%20the%20experiment%20ID%20(column%20B)%20is%20determined%20by%20the%20text%20in%20column%20E%20(here%3A%20test).%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22imdmeyer_0-1629383431591.png%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304427i9309A35EC440D45C%2Fimage-dimensions%2F624x78%3Fv%3Dv2%22%20width%3D%22624%22%20height%3D%2278%22%20role%3D%22button%22%20title%3D%22imdmeyer_0-1629383431591.png%22%20alt%3D%22imdmeyer_0-1629383431591.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22imdmeyer_1-1629383601189.png%22%20style%3D%22width%3A%20245px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304428i26EDFC2DAB806427%2Fimage-dimensions%2F245x196%3Fv%3Dv2%22%20width%3D%22245%22%20height%3D%22196%22%20role%3D%22button%22%20title%3D%22imdmeyer_1-1629383601189.png%22%20alt%3D%22imdmeyer_1-1629383601189.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2665518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2665701%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20text%20of%20cell%20into%20another%20tab%20based%20on%20its%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665701%22%20slang%3D%22en-US%22%3ESince%20you've%20created%20a%20spreadsheet%20(presumably)%20in%20order%20to%20create%20those%20images%2C%20would%20it%20be%20possible%20to%20actually%20post%20the%20spreadsheet%3F%20That%20way%20some%20of%20us%20could%20use%20it%20(rather%20than%20creating%20our%20own%20secondary%20version)%20to%20demonstrate%20various%20methods.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I want to create a table in a second tab (2nd figure), where all the experiment numbers which have a certain color (1st figure), line up into a column. In this way, all the different types of experiments are The color of the experiment ID (column B) is determined by the text in column E (here: test). 

imdmeyer_0-1629383431591.png

imdmeyer_1-1629383601189.png

Any help would be greatly appreciated.

 

1 Reply
Since you've created a spreadsheet (presumably) in order to create those images, would it be possible to actually post the spreadsheet? That way some of us could use it (rather than creating our own secondary version) to demonstrate various methods.