VBA If statement............
Posted by Daniel on November 19, 2001 2:20 PM
In my spreadsheet I hold stock names, prices, etc and 2 level counts. Store level & Critical level.
I have another column with the formula:
If Stock level <= Critical level Then
Now I would like to create a module that searches through this column and finds all the "Yes" values and prints the row data of that product to another sheet.
I've been using For Each Next loops but im rusty with my VBA.
Hope you can help, if you need to know any more details just mail me.