When a value is detected in a cell, a VBA code or function will insert a new row with specific values and functions already in each cell

[ubergreen]

Been trying to wrap my head around this one.

I need my Sheet1 to be able to create a new row whenever it encounters a cell that has a value in it other than 0 on Sheet2, which in this case would be A4, A10
and A13. I would like for this to be done automatically for all rows in Sheet1.

I am not sure if it will make much of a difference, but Sheet2 will actually be a different workbook, which I can simply call Workbook2. I just put the example as sheets to make it visually easier to view.

Sheet1 below. I wrote the formulas/functions that I am using for this sheet to fill in the current values

Sheet2 below, which is being used as the reference sheet for Sheet1

This is how I want the new Sheet1 to look like after.
- A new row is inserted above Order 1007,1004, 1001.
- The value from the cell below the new row is used to fill the new cell in column A
- The formula/value "TRUE" will always be applied for every cell in column B
- The quantity for the cell in the new inserted row will always be a 0 in column C
- The Taxes from Sheet2 will be added in the new row under Price in column D
- The State information will be duplicated for every cell in column E for that particular Order