help please

%3CLINGO-SUB%20id%3D%22lingo-sub-2127019%22%20slang%3D%22en-US%22%3Ehelp%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2127019%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20lot%20of%20data%20in%20'sheet1'%20the%20data%20has%20to%20be%20distributed%20trough%20out%20other%20sheets%2C%20column%20b%20has%20the%20values%20chc20%20to%20chc50%2C%20for%20example%20i%20need%20to%20get%20the%20row%20data%20from%20chc20%20to%20sheet%202%20chc30%20on%20sheet%203%20etc.%20the%20data%20wil%20be%20constantly%20changed%20in%20sheet%201%20so%20i%20can't%20keep%20copy%20pasting%20them%20in%20and%20i%20want%20to%20do%20this%20automatically%2C%20any%20help%20%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2127019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2128854%22%20slang%3D%22en-US%22%3ERe%3A%20help%20please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F964546%22%20target%3D%22_blank%22%3E%40IzeyVdh%3C%2FA%3E%26nbsp%3BDo%20you%20have%20access%20to%20the%20FILTER%20function%3F%20If%20so%2C%20have%20a%20look%20at%20the%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

i have a lot of data in 'sheet1' the data has to be distributed trough out other sheets, column b has the values chc20 to chc50, for example i need to get the row data from chc20 to sheet 2 chc30 on sheet 3 etc. the data wil be constantly changed in sheet 1 so i can't keep copy pasting them in and i want to do this automatically, any help ?

2 Replies

@IzeyVdh Do you have access to the FILTER function? If so, have a look at the attached workbook.

 

@IzeyVdh 

I don't understand your plan. Could you explain in more detail which cells should go into which cells.

At the same time I prepared an approach in Sheet 2, even if I don't think it can be in the right direction. Take a look at it and please let us know if this is OK, or describe it in more detail HOW it should be.

 

Thank you for your patience and understanding

 

Nikolino

I know I don't know anything (Socrates)