I need to count the number of orders that have not been reviewed yet. I have
been using countblank(O43:O5687). this works as long as some one updates the
formula when new orders are added. I am thinking I want a macro that will
find the last row using the order number in column A , then count the blank
cells in column O for order review, and also count the blank cells in
column t for outstanding orders.

Thanks
Clayton