Moving Cells

[SprAmos]

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 cells on the 'stock' based on i
the number in the 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 ro
that has a number above '0' then two cells from that row appear i
'order'

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