excel - Copy rows with Qty>0 -

I want to create an Excel formula (without using VBA) to fill a sheet named "Bill" based on another formula I am "Prescription".

I have 10 rows in the sheet "Prescription" with column heading, quantity, value and total. I want to copy the rows, where without the blank rows, for the sheet "bill" 0>

I know that it is easy to do with VBA, I just want to copy every line (empty Rows), set an AutoFilter to hide 0 seconds, and then add some VBA to refresh the filter, but I'm pretty sure I can do it without VBA (maybe with an array formula. Some non -0 value).

So this is "prescription":

  title | Volume | Price | Total ---------------------- Test 1 | 0 | 99.99 | 0 Test 2 | 1 | 99.99 | 99.99 TEST 3 | 0 | 99.99 | 0 Test 4 | 3 | 99.99 | 299.97  

I want a formula to get another sheet:

  title | Volume | Price | Total ---------------------- Test 2 | 1 | 99.99 | 99.99 Test 4 | 3 | 99.99 | 299.97  
 
 How about MS Query ?: 
 
 < Code> SELECT * FROM [Prescription $] ASS Virus quota & gt; 0  
 
 Use data> get external data-> MS query or you can also create a simple add-in I: 
 
 Once you You can refresh it at any time by right-clicking on the question table and refreshing it.