I have 2 tabs. The first tab has all of my inventory items listed. The second tab is my order tab. What i need is on the second tab I need it to look at the inventory tab at the "D" column and if there is a number in a row then it needs to copy the whole row over. It needs to continue doing this for all 50 rows while skipping blank rows. So that on the second tab I have only the items I need to order but with no blank lines.

Any and all help is appreciated.