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

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies