How to insert rows by changing drop down list numbers

**krish T** · 10-01-2013, 01:19 PM

Hi, Please find the attached excel sheet with the example

Question 1: How to insert rows based on changing "Check4" values from drop down list immediately after that row. If check4 value is 1 means I want to add one row; if it is 2, then I want to add 2 rows. This has to happen automatically when I change Check4 value without executing any macro manually if it is possible. And also it has to copy the data and formula's from row2 to the added rows. This should be the case with Column D. If I change the numbers in Column D, it has to add rows immediately after that row along with copying the data and formula

Question 2: How to enable drop down list which I have created in cell D2 to other rows in the same column without creating manually in the attached excel sheet

Can you help me to get the above answers.

Sincerely
Krish

**Solus Rankin** · 10-01-2013, 01:31 PM

Perhaps: Test.xlsm

**krish T** · 10-01-2013, 11:26 PM

Thanks Solus for the quick answer. I am also looking to copy the data & formula to inserted rows when changing Check4 values.

Thanks
Krish

**Solus Rankin** · 10-01-2013, 11:39 PM

Like this? Attachment 268555

Sorry. Bad attachment. Let me repost.

**Solus Rankin** · 10-01-2013, 11:42 PM

How about: Test.xlsm

**krish T** · 10-02-2013, 01:01 AM

Thanks Solus for the reply. I am not able to see the macro in the given excel sheet. Can you resend the file again so that I can see the code in View Macro option

Thanks
Krish

**krish T** · 10-02-2013, 02:45 AM

Hi Sous, I am able to see the macro. Please ignore my previous message. But I am seeing formula error when copying the data in inserted row. Attached is the spreadsheet with the example. When I am giving input 1 in Cell G3, Cell F5 formula is showing error. How to avoid this formula error when copying the data and formula.

Thanks
Krish

**Solus Rankin** · 10-02-2013, 06:55 AM

Check the formulas in your original spreadsheet before running the macro. There isn't a formula in F2 and the rest of the formulas seem to be off by one cell. They are not the same formulas that you included in your original example.

What are the formulas actually going to be?

**krish T** · 10-05-2013, 09:56 AM

This is my intention not to give formula in F2. Formula started from F3 in column F. This formula is linking with the values in the same row and the previous row. In this case in F3 is =E3*D2 and in F4 is =E4*D3, so when I add a row using macro in G3 by selecting 1, 4th row seems to be ok in F4 (=E4*D3) but 5th row not seems to be ok in F5 (=E5*D3) because actually it should be =E5*D4. I hope you got the problem.

Thanks
Krish

How to insert rows by changing drop down list numbers

LinkBack

Thread Tools

Rate This Thread

Display

How to insert rows by changing drop down list numbers

Re: Inserting rows based on change in drop down list number

Re: Inserting rows based on change in drop down list number

Re: How to insert rows by changing drop down list numbers

Re: How to insert rows by changing drop down list numbers

Re: How to insert rows by changing drop down list numbers

Re: How to insert rows by changing drop down list numbers

Re: How to insert rows by changing drop down list numbers

Re: How to insert rows by changing drop down list numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change a cell based on a drop down list

[SOLVED] Inserting number of rows based on a count of data

Inserting rows based on unknown number of tabs

Inserting New Rows Based on Number in Column

[SOLVED] change info in other cells when i change a number in a drop list?

Bookmarks

Bookmarks

Posting Permissions