Hi,

"I'm working on a sheet were sheet 1 has the summary of all the sheets
from sheet 2 to sheet 32.
I have to work on number of batches, in which 1 batch have an
max count of 50. So I have given a countif function in cell D2. saying that
whenever there is "completed" in cell G10:G110 show me the count of
"Completed" in Cell "D2", as once I reach to the count of 50 I need to
close
that particular batch.
So I have given similiar Countif function in Cells as below: -
D2,E2,F2,G2,H2,I2 and J2 on all the sheet from sheet 2 to Sheet 32.

In Short what I want is a message box should pop up saying "Do you want to
Close the Batch" whenever there is a count showing as only 50 in the Cells
D2,E2,F2,G2,H2 and J2 on all the sheets from sheet 2 to Sheet 32 that I have
in the workbook, except the sheet1 which has the summary report.

--
vijay

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming