Dynamically populate rows based on values in column

%3CLINGO-SUB%20id%3D%22lingo-sub-2795533%22%20slang%3D%22en-US%22%3EDynamically%20populate%20rows%20based%20on%20values%20in%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2795533%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20a%20dozen%20sheets.%20Each%20sheet%20has%20a%20table%20with%20identical%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20each%20sheet's%20table%20to%20contain%20the%20table%20values%20from%20the%20first%20sheet%20where%20the%20final%20cell%20in%20the%20first%20sheet's%20table%20is%20the%20corresponding%20number%20of%20that%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEXAMPLE%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20every%20row%20in%20sheet%20one%20with%20a%20'0'%20in%20the%20last%20cell%20that%20whole%20row%20needs%20to%20populate%20in%20the%20table%20of%20the%20next%20sheet%20titled%20'0.%20Intake'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20every%20row%20in%20sheet%20one%20with%20a%20'1'%20in%20the%20last%20cell%20that%20whole%20row%20needs%20to%20populate%20in%20the%20table%20of%20the%20next%20sheet%20titled%20'1.%20New%20Orders'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20sheet%20is%20meant%20to%20include%20ALL%20rows%20while%20each%20sheet%20should%20only%20contain%20the%20rows%20with%20the%20designated%20number%20as%20a%20kind%20of%20advanced%20sorting.%20Every%20time%20the%20number%20in%20the%20last%20column%20of%20the%20first%20sheet%20changes%2C%20that%20row%20should%26nbsp%3B%3CEM%3Emove%3C%2FEM%3E%20from%20the%20previous%20sheet%20it%20populated%20to%20the%20sheet%20the%20updated%20number%20corresponds%20to.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2795533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2804707%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20populate%20rows%20based%20on%20values%20in%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1170169%22%20target%3D%22_blank%22%3E%40cjonespsusa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20you%20have%20a%20screen%20shot%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a workbook with a dozen sheets. Each sheet has a table with identical headers.

 

I need each sheet's table to contain the table values from the first sheet where the final cell in the first sheet's table is the corresponding number of that sheet.

 

EXAMPLE:

 

For every row in sheet one with a '0' in the last cell that whole row needs to populate in the table of the next sheet titled '0. Intake'

 

For every row in sheet one with a '1' in the last cell that whole row needs to populate in the table of the next sheet titled '1. New Orders'

 

The first sheet is meant to include ALL rows while each sheet should only contain the rows with the designated number as a kind of advanced sorting. Every time the number in the last column of the first sheet changes, that row should move from the previous sheet it populated to the sheet the updated number corresponds to. 

1 Reply

@cjonespsusa 

 

do you have a screen shot