Return a range from a range

[kborgers]

I am stumped so any ideas will be much appreciated. I want to return a range of data from another range as in the attached example. Column A contains the number of days before an item needs to be reordered and column B contains the appropriate stock code of each item. I expected this to be simple (it probably is but perhaps I'm making it complicated!). I want to search column A, find a value over zero and report both it and the appropriate stock code from column B and heve them appear in columns C and D ina new list that ignores all zero values. As an added twist, I would ideally like to see the list sorted from smallest to largest value. I have considered VLOOKUP and INDEX but I confess I'm getting out of my league here!

[carsto]

Do you know about autofilter?
Select the Row containing your Headers (probably Row 1, but Row 2 in your sample workbook)
Select Data > Filter > AutoFilter then a Filter selection drop down will appear on every cell in Row 1
Select the Days Stock filter then select Custom and "is greater than" and enter Zero.

you will filter down to the items with Stock Qty > 0

they won't be in ascending order, unless you sort the list first in ascending order.

This would be the simplest method.

Otherwise you will need a macro to place the results in another column.

[Palmetto]

You could Advanced Filter with criteria to create the list. See this link for help on using Advanced Filter

More help with Advanced Filter

In the attached, I've created the list ( gray shaded cells) using advanced filter with the criteria (green shaded).

[kborgers]

Thanks Guys. I was not familiar with advanced filtering and having looked, it does the job as well as required. I would prefer to have this information appear automatically in separate columns but beggars can't be choosers! I have not the time (although I have the will!) to start learning VBA so this is as good a workaround as I can expect. Thanks again both - much appreciated!