Printing Reports
Printing Reports
(OP)
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
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





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