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

The totals should be in cells b3 and b6
"DCR" wrote in message ...
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

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DCR" wrote in message ...
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

I suggested a self adjusting defined name range to use in the formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DCR" wrote in message
...
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