I have exactly the same question. I have the list for inventory and if the
item number is lower than reorder level, then there will be a "warning"
written at the beginning of the row automatically. Then I want to copy those
rows with "warning" to another sheet, then I can generate my reorder list. So
how can I do?? Thank you!