Hi Forum,
I need help on the below task which i could break down into steps to follow and i would request contributors to help me out with this task.
Instructions:
Step1 : Need to filter "OK" in all Columns H to M and fill those visible rows in column T as "IN", column U as "NO"
Step2: Filter out all and For next step filter only blank cells in column U
Step3 : Then filter column F with "M" then come to column H and filter out "OK" and fill those visible rows in column T as "IN", column U as "Yes"
Step4: Filter out all and for next step filer only blank cells in column U
Step5: Then filter column F with "F" then come to columns I to M and filter without "OK" as criteria (means select all, other then "OK")
Step5: fill those visible cells in column T as "OUT" and Column U as "SETOUT"
Step6: remaining unfilled blank cells left in column T and U are expected to fill with column T as "IN", column U as "Yes"
Step7: Unfilter all
Thank you.
Bookmarks