If greater than 0

[dillanejohn]

Hi could do with some help please.
I have a spread sheet with many items on it . Basically my spread sheet is a shopping list.
I have 150 items on this spreadsheet and i might only require 30 of them. Once I have selected the items i require how do i get these items to automatically
appear further down my spread sheet, like a shopping list. I have a drop down list of numbers in my quantity column along side each item. At the moment the quantity is blank and once i click the quantity I need I want it to automatically copy the whole row to a point further down my spread sheet, all listed one after the other.

Thank you.

 

[SanjayGMusafir]

You can use FILTER Function to get a Shopping List

 

[dillanejohn]

Thank you Sanjay. Sorted.

 

[SanjayGMusafir]

Thank you Sanjay. Sorted.

Glad to help you