i require help,

my project is simple.

a 'stock' sheet on one page and then a 'order' sheet on the second.

i want the order sheet to return two cellsfrom the 'stock' sheet based on if the number in a column is above 0.

so if 'E4' on 'stock' has a '1' i want E4 & F4 to appear in the 'order' sheet

i want this formular to apply to all the rows in 'stock' so that any row that has a number above '0' then two cells from that row appear in 'order'

hope what im asking makes sense, ask if you need more info.