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
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