Printing Reports

[Crashtestdummy]

Hey all,

I'm writing an excel worksheet that will allow people to print pro-forma orders. What I am trying to do is that when they enter a stock value in this spreadsheet, and the value is lower than the minimum stock level set, for it to show up on an order. If the value entered is higher than the minimum value then it cant show on the pro-forma.
I'm hoping there is an easy way to do it.

Thanks in advance for your help people

Crash

 

[TejuKey]

You can compare the value in a cell to a set value and then have it trigger the routine to add to an order or not:

If Cells(row, column).Value > SomeNumber
Do Something
ElseIf Cells(row, column).Value < Then
Do SomethingElse
End If