Forum Discussion
Run Multiple sets of data through set formula's
Yes, you should not post confidential data, but your sample data and description are too incomplete and vague for proper formulas. The "run multiple sets of data through it" suggests that you will paste a rectangular, horizontal range of values to the right of the cells filled with "Orange" (I would call it khaki), but pasting a vertically-oriented range in a differently structured worksheet is also possible.
Many Excel functions can be used to spill formula results to additional, adjacent (down and/or to the right) cells. Play with the SEQUENCE function for an example of where you (presumably) know the number of cells spilled to when you write the formula. And the XLOOKUP function can take a linear range of cells or an array as its first argument (lookup_value), generating a result range of similar structure.
See the attached workbook for one set of possibilities.