Auto insert 'x' rows depending on value 'y'

Closed

nephilim3uk

Posts: 11
Registration date: Monday August 9, 2010
Status: Member
Last seen: October 27, 2010

- Aug 9, 2010 at 02:43 AM
rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

- Aug 17, 2010 at 09:45 PM

Hi,
I have an excell spreadsheet that contains a table. I want to be able to insert a given number of rows dependant on the value inserted to a particular cell. So if value is '3' , it will insert 3 rows, if value is '6' it will insert 6 rows and so on.
Any suggestions welcome. I have limited experience in using macros and almost none with vb

many thanks

How to insert rows in excel automatically based on cell value
Excel generate rows based on cell value - Best answers
Excel add rows based on cell value - Best answers
Insert rows on change of value in Excel table ✓ - Forum - Excel
Macro to insert row in excel based on criteria - Forum - Excel
Excel move row to another sheet based on cell value automatically ✓ - Forum - Excel
Code for macro that conditionally inserts rows ✓ - Forum - Excel
How to insert blank rows in excel automatically - Guide

3 replies

Answer 1 / 3

nephilim3uk

Posts: 11
Registration date: Monday August 9, 2010
Status: Member
Last seen: October 27, 2010

1
Aug 12, 2010 at 06:04 AM

Hi

I still cant figure this out, even with teh sample data. My spreadsheet is as follows;

Column A
Invoice Date - input by user

Column B
Invoice Number - Input by user

Column C
Invoice Total - Input by user

Column D
Number of Budget Centres invoice is split accross - Value 1-60 input by user

Column E
Value of invoice per budget centre - automatically calculate C divided by D

Columns F - O
Additional data - input by user

I want the sheet to automatically insert the number of rows indicated in column D minus 1 (the existing row becomes row 1) Also the value calculated in Column E should be copied into the new rows.

Suggestions to date appreciated, any further advice greatly received.

regards

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

768
Aug 17, 2010 at 09:45 PM

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Answer 2 / 3

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

768
Aug 9, 2010 at 02:18 PM

See this
https://ccm.net/forum/affich-333050-how-to-repeat-rows-by-x-number-of-times

nephilim3uk

Posts: 11
Registration date: Monday August 9, 2010
Status: Member
Last seen: October 27, 2010

1
Aug 10, 2010 at 03:24 AM

Hi

Thanks for this, looks like it could do the trick.
Forgive my ignorance though, can I check the following;
1- Do I put this code on the VB editor for the sheet (right click sheet, view code) ?
2- Do I need to add or change anything to the code ?

thanks again

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

768
Aug 10, 2010 at 02:25 PM

#1 Once you start VBE, You would add a new module and paste the code in that newly added module

#2 If you sheet looks like the sample data there, then nothing needs to be changed

Similar discussions

Conditional formatting: change fontcolor based on another cell

Duplicate rows based on cell value

Excel VBA copy and paste loop with logic condition

Code to move rows into another sheet based on certain values

Copy rows to other sheets based on value in column

Excel - Repeat rows to a specific number of times

Similar discussions

Subscribe To Our Newsletter!