Open window with data from other sheet

You can't add a unit price without overwriting the formula.

I think you will find that problems will continue to crop up. The best thing is to pln your project step by step before starting, strangely in this computer age a pen & paper helps. If you do this you will then be able to check if any steps will cause problems later.

The simplest way to add rows is to et up upur template with sufficient rows & hide the extra ones. Then in the code you can unhide rows as required.