Home

Auto Populate a Block (row) of Cells in One Sheet Based On Numerical Value in Cells on Another Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-909987%22%20slang%3D%22en-US%22%3EAuto%20Populate%20a%20Block%20(row)%20of%20Cells%20in%20One%20Sheet%20Based%20On%20Numerical%20Value%20in%20Cells%20on%20Another%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909987%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Y'all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20by%20the%20title%2C%20I%20don't%20even%20know%26nbsp%3B%3CEM%3Ewhat%3C%2FEM%3E%20formula%20I%20need%20to%20execute%20in%20order%20to%20accomplish%20what%20I'm%20hoping%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(First%20Image)%20On%20Sheet%20One%20I%20have%20a%20table%2C%20in%20one%20of%20the%20columns%20of%20the%20table%2C%20each%20cell%20contains%20a%20different%20number%20-%20column%20O%20cell%206%20is%2010%20representing%2C%2010%20min.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Second%20Image)%20I%20need%20to%20find%20a%20way%20to%20auto%20populate%20a%20row-block%20of%20cells%20on%20another%20sheet%2C%20equal%20to%20the%20number%20(O6%3D10)%20in%20the%20cells%20on%20the%20first%20sheet.%20Ideally%20these%20blocks%20would%20be%20movable%20without%20effecting%20the%20borders%2C%20fills%2C%20etc.%20of%20the%20chart.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20in%20the%20second%20image%2C%20it%20would%20create%20a%20row-block%2C%2010%20cells%20long%20which%20can%20be%20moved%20and%20placed%20where%20we%20need%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20936px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137257i8DD20E8B1D703334%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-10-11%20at%203.41.33%20PM.png%22%20title%3D%22Screen%20Shot%202019-10-11%20at%203.41.33%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20508px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137259i0FB80B984ED5E781%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-10-11%20at%203.44.37%20PM.png%22%20title%3D%22Screen%20Shot%202019-10-11%20at%203.44.37%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-909987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
NotAsSmartAsILook
Occasional Visitor

Hey Y'all,

 

As you can see by the title, I don't even know what formula I need to execute in order to accomplish what I'm hoping to do. 

 

(First Image) On Sheet One I have a table, in one of the columns of the table, each cell contains a different number - column O cell 6 is 10 representing, 10 min.

 

(Second Image) I need to find a way to auto populate a row-block of cells on another sheet, equal to the number (O6=10) in the cells on the first sheet. Ideally these blocks would be movable without effecting the borders, fills, etc. of the chart. 

 

As you can see in the second image, it would create a row-block, 10 cells long which can be moved and placed where we need it. 

 

Thanks in advance!

 

Screen Shot 2019-10-11 at 3.41.33 PM.pngScreen Shot 2019-10-11 at 3.44.37 PM.png