Create a list Excel

[Jeronkie]

Hi Guys ,
I need help , searched and played with some suggestions on other posts but must be doing something wrong

1) As attached document I have a store inventory with items in "B" part number in "C" stock number etc etc "K-NK" is 365 days of the year
if you use 1 item the 1st of Jan you will enter a 1 it will subtract stock and indicate in "I" how many need to be ordered

So this is where i need help ,
on the "order" tab (other page) I need to list the items with part number that we need to order , there will be many items on the main page but I just need the items listed without gaps on the order page

line 8 don't need to be ordered , but need to order 5 of line 9 (with description , number and quantity)

Clearly my skills is not at that level

Can someone help please

Regards Beria

[AlKey]

Please see attached file with formula.

[Jeronkie]

Thx AlKey

it will take me some time to understand , but that is how we learn

Please PM you details ,

Jeronkie

[AlKey]

Thank you for the feedback!

Hi Jeronkie, I just updated your attached file in post #2. There are minor changes in column names.