Copying rows of data to rows in other sheets, based on criteria in one column

%3CLINGO-SUB%20id%3D%22lingo-sub-2279318%22%20slang%3D%22en-US%22%3ECopying%20rows%20of%20data%20to%20rows%20in%20other%20sheets%2C%20based%20on%20criteria%20in%20one%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279318%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20seen%20other%20posts%20but%20none%20of%20them%20seem%20to%20get%20me%20to%20the%20right%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20four%20sheets%20that%20this%20data%20needs%20to%20be%20sorted%20into%2C%20based%20on%20criteria%20in%20one%20column%20(D).%20There's%20data%20through%20column%20P%2C%20though%20all%20of%20that%20data%20is%20loaded%20into%20each%20sheet%20based%20on%20the%20criteria%20in%20column%20D.%20Ideally%20the%20columns%20would%20stay%20as%20is%20so%20I%20wouldn't%20need%20to%20mess%20with%20the%20data%20once%20I%20download%20it%20from%20Power%20BI.%20There's%20only%20four%20different%20criteria%20in%20column%20D%2C%20and%20I%20need%20ALL%20of%20the%20columns%20that%20fit%20that%20criteria%20to%20load%20into%20column%20D.%20The%20amount%20of%20columns%20could%20vary%20greatly%20week%20to%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuggestions%3F%20THANK%20YOU%20in%20advance!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279318%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
Visitor

I've seen other posts but none of them seem to get me to the right solution.

 

I have four sheets that this data needs to be sorted into, based on criteria in one column (D). There's data through column P, though all of that data is loaded into each sheet based on the criteria in column D. Ideally the columns would stay as is so I wouldn't need to mess with the data once I download it from Power BI. There's only four different criteria in column D, and I need ALL of the columns that fit that criteria to load into column D. The amount of columns could vary greatly week to week.

 

Suggestions? THANK YOU in advance!!

0 Replies