Auto inserting rows and formula

[MartinjLane]

Hi

I have an "Audit template" in which I need to automatically insert rows and copy formula depending if the previous row has data.

e.g. I may audit 1 location with only 4 items but the next location may have 100 items.

I have created a sheet that starts with 1 row. If this row is populated with data I need the sheet to automatically insert a row and copy the formula down. This doesn't have to be automatic, it could be done on carriage return of the previous data

I have attached a sample sheet. Appreciate any help.

Martin