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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 09:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 09:45 PM
Related:
- Excel add rows automatically based on cell value
- Insert number of rows based on cell value - Best answers
- Add rows based on cell value in excel - Best answers
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Pdf and xps add in 2007 - Download - Other
- Transfer data from one excel worksheet to another automatically - Guide
- How to add @ in laptop - Guide
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
3 responses
nephilim3uk
Posts
11
Registration date
Monday August 9, 2010
Status
Member
Last seen
October 27, 2010
1
Aug 12, 2010 at 06:04 AM
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
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
Aug 17, 2010 at 09:45 PM