I still cant figure this out, even with teh sample data. My spreadsheet is as follows;
Invoice Date - input by user
Invoice Number - Input by user
Invoice Total - Input by user
Number of Budget Centres invoice is split accross - Value 1-60 input by user
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.