Hi,

"I'm working on a sheet were sheet 1 has the summary of all the sheets
from sheet 2 to sheet 32 day(where sheet 2 to sheet 32 is number of days max
31day in a month)and which has the actual data.
On a given day 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,E2,F2,G2,H2,I2
and J2 on each sheet. Were cell D2 is for the first batch, cell E2 is for
second batch, cell F2 for third batch and so on.
What I want is whenever cell D2,E2,F2,G2,H2,I2 and J2 shows up a count of
50, it should show up a message box saying "" Do you want to Close the
Batch?"".
Whereas Cell D2 will show up count 50 for the first batch and thereafter the
second batch, so there is the time difference in each batch. So whenever the
above cells show an count of 50 it should pop up with the above message.
I want a macro for this. but the macro should not include sheet 1 because it
has the summary of the rest of the sheets.


--
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

It's difficult to come up with a solution with partial information. Where
does the data from D2, E2, F2, etc. come from?

FWIW, this really isn't something that would be a suggestion.

"vijay" wrote:

Hi,

"I'm working on a sheet were sheet 1 has the summary of all the sheets
from sheet 2 to sheet 32 day(where sheet 2 to sheet 32 is number of days max
31day in a month)and which has the actual data.
On a given day 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,E2,F2,G2,H2,I2
and J2 on each sheet. Were cell D2 is for the first batch, cell E2 is for
second batch, cell F2 for third batch and so on.
What I want is whenever cell D2,E2,F2,G2,H2,I2 and J2 shows up a count of
50, it should show up a message box saying "" Do you want to Close the
Batch?"".
Whereas Cell D2 will show up count 50 for the first batch and thereafter the
second batch, so there is the time difference in each batch. So whenever the
above cells show an count of 50 it should pop up with the above message.
I want a macro for this. but the macro should not include sheet 1 because it
has the summary of the rest of the sheets.


--
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