Home

Need to insert grouped rows in Ecel

%3CLINGO-SUB%20id%3D%22lingo-sub-633151%22%20slang%3D%22en-US%22%3ENeed%20to%20insert%20grouped%20rows%20in%20Ecel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633151%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%26nbsp%3B%20list%20of%20364%20clients.%20I%20need%20to%20insert%20nine%20(9)%20rows%20after%20each%20client%20with%20the%20names%20of%20the%20functional%20areas%20that%20touch%20their%20product%20and%20have%20them%20grouped%20to%20the%20client%20within%20the%20column.%20I%20do%20need%20entire%20rows%20to%20be%20inserted%20as%20there%20will%20be%20data%20entered%20under%20other%20column%20headings%20associated%20to%20each%20functional%20area.%26nbsp%3BI%20would%20love%20to%20find%20a%20solution%20to%20make%20this%20automated%20as%20it%20could%20take%20hours%20to%20insert%20and%20group%20this%20many%20lines%20and%20this%20will%20need%20to%20be%20repeated%20monthly.%20I%20am%20a%20novice%20at%20VBA%20but%20not%20afraid%20of%20it.%20I've%20tried%20a%20couple%20of%20row%20inserting%20macros%20but%20have%20not%20be%20able%20to%20write%20anything%20that%20comes%20close%20to%20what%20I%20need%20the%20worksheet%20to%20do.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
Not applicable

I have a  list of 364 clients. I need to insert nine (9) rows after each client with the names of the functional areas that touch their product and have them grouped to the client within the column. I do need entire rows to be inserted as there will be data entered under other column headings associated to each functional area. I would love to find a solution to make this automated as it could take hours to insert and group this many lines and this will need to be repeated monthly. I am a novice at VBA but not afraid of it. I've tried a couple of row inserting macros but have not be able to write anything that comes close to what I need the worksheet to do.  

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies