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

3 replies

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