Hi Guys,
Please help me on the user defined function i have created in VBA considering many conditions.
Below are the conditions.
STEP QTY LOT STATUS Result
SORT1 or SORT2 = 0 or blank PREQ OK
SORT1 > 0 PREQ Move to Sort1 POSTQ
SORT1 > 0 POSTQ Move to Sort2 PREQ
SORT2 > 0 PREQ Move to Sort2 POSTQ
SORT2 > 0 POSTQ Move to DI
I tried creating below function however, when I tried to run it with different conditions, I am only getting one result which is "Move to Sort1 POSTQ"
Appreciate the feedback.Please Login or Register to view this content.
Thanking everyone in advance.
Bookmarks