Home

Duplicate (copy) rows based on cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-688578%22%20slang%3D%22en-US%22%3EDuplicate%20(copy)%20rows%20based%20on%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688578%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20trying%20to%20figure%20out%20a%20macro%20or%20VBA%20script%20that%20would%20look%20at%20a%20cell%20(total%20count)%20for%20the%20said%20row%20and%20then%20duplicate%20that%20row%20X%20number%20of%20times%20based%20on%20that%20cell%20value.%20Then%20move%20on%20and%20repeat%20for%20all%20the%20following%20rows.%20I've%20been%20able%20to%20do%20it%20based%20on%20a%20singular%20value%2C%20or%20manually%20selecting%20a%20row%20and%20inputting%20my%20own%20value%20to%20duplicate%20the%20row.%20I'm%20really%20trying%20to%20automate%20this%20process.%20Thanks%20for%20any%20help%20you%20can%20provide!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-688578%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%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MoocowJay
Occasional Visitor

I've been trying to figure out a macro or VBA script that would look at a cell (total count) for the said row and then duplicate that row X number of times based on that cell value. Then move on and repeat for all the following rows. I've been able to do it based on a singular value, or manually selecting a row and inputting my own value to duplicate the row. I'm really trying to automate this process. Thanks for any help you can provide!

Related Conversations