Insert rows depending on user input

April 10, 2013 at 06:19:14
Specs: Windows 7
I'm collating data in Excel 2010 on how many projects colleagues are working on.

I want them to be able to input in a column e.g. "2" (meaning working on two projects) and therefore an additional row will be added underneath to make two rows in which to fill out their project requirements.

I'm assuming a macro is needed...but have no experience with VBA.

Any help would be much appreciate,


See More: Insert rows depending on user input

Report •

April 10, 2013 at 12:09:32
Without knowing the layout of your spreadsheet, it's hard to provide a definitive solution.

You said you want the user to enter a 2 in a column (which column?) and have an "additional row ... added underneath".

That will give them 1 extra row, so what will happen with the row that has the 2 in it? Is that row still used for "project requirements" or do you actually need 2 rows added if a 2 is entered?

A little more detail might help point us in the right direction.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

April 11, 2013 at 02:30:42
1 Number of reports Name -
2 - John -
3 - Mark -
4 - Luke -
5 - Matthew -

Thanks for the advice,

I'd like it so that if "John" inputs a 2 in cell A2 a macro will input a row underneath which is a copy of the row prior to it...i.e. a new row 3 forms, pushing "Mark" into cell B4 as his row is moved down.

So the number of rows to be inserted is equal to number inputted into "Number of Reports" column less 1. So John inputs 2, number of rows inserted is 2 - 1.

Hope that makes sense - or perhaps you can recommend a better methodoloy?

Best regards,

Report •

April 11, 2013 at 04:06:26
Please click on the following line and read the instructions on how to post example data in this forum. Then repost your example so that we can exactly how the columns line up.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question