Delete row in sheet if value in column blank

[Pearly_King]

Please bear with me on this...

I am using MacOS and an older version of MS Office (2011)

I have a spreadsheet that on sheet 2 I enter values in column C.

Sheet 1 has been formatting using simple IF function to show the row as blank if the value in column B in sheet 1 is <0.

If value in column B on sheet 1 is >0 then a description from column A sheet 2 is displayed in the row.

This is as far as I've got.

I know nothing of macros or how to enter code etc. so if the solution is to use a macro then I will need guided through the whole process. My current skill set extends to simple function commands.

I'd like the blank rows in sheet 1 to auto delete so that only those with values are shown.

There is a simple SUM function under the rows in column B, then a VAT calculation, and a gross figure at the bottom

Hope all this makes sense and help would be appreciated