Remove lines from spreadsheet that have the value 0

Hi!

I have enclosed 3 pictures with my question.
1. Is where the user is putting in data.
2. Is a spreadsheet with the data choosen from the action of the user, but it is containing also the non-choosen data from the input spreadsheet.
3. IS how I want the data shown to me either automatic or thru a macro.

So is there any code like IF or some Macro who would make this happen?

What I want at the end of the day is a list of products that the user have put in and nothing else, with the QTY and price and the sum of that.

I would be glad if somebody couød help me or send me in the right direction!

ZZ

UserInput.jpg

CopyDataSheet.jpg

Wanted.jpg

You can filter this table in place.

1) Click on row 2 and activate the DATA > FILTER > AUTOFILTER.
2) Click on row E's drop down and select CUSTOM
3) Use Greater than - zero

This give you the appearance of your Wanted.jpg without having to delete anything.

If you want to actually delete them, then:

1) Click on row 2 and activate the DATA > FILTER > AUTOFILTER.
2) Click on row E's drop down and select ZERO (this will show all rows with zero)
3) Highlight all the visible rows and delete them
4) Turn off the AUTOFILTER and the remaining rows will reappear just like your Wanted.jpg