Adding a line to quoting/estimating tool

[Sean_WS]

Probbably a really simple solution to this..

When my coleagues are quoting, sometimes it could be for 10-15 rows others could be up to 500 rows. instead of them constantly adding lines to the sheet and running the risk of removing formulas, is there a way that I can have a row or two where when one is filled in with data that another row is automatically inserted with the same formula/formatting as the row above? Starting from C7 to I37. image attached.

The only caviat is that this data is also copied across to another sheet ='Sheet1'!C37 etc. I imagine with that I would need to do a similar formula/macro on this sheet to also add additional lines as the one above is filled Data?

Hopefully that makes sense XD

 

[AFPathfinder]

You could convert the range into a table and it should autofill the formulas to newly started rows. Should work if they use the next blank row or inserting a new row.

You could write a macro that inspects the table and extends formulas as necessary; probably triggered by an event like BeforeSave.

My favorite option is to create a userform for the users to enter the data and just have the userform macros manage the table. That's probably a lot more work than this solution needs, though.