Sorry if my description was unclear. Each day's report becomes a new sheet
in the same workbook

"Bernard Liengme" wrote:

> Would be nice if you told us more about the workbook. Like were is the data
> for each day of the week? - on the same worksheet or on its own worksheet.
> Tell us what we need to help you.
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "blackgold21" <blackgold21@discussions.microsoft.com> wrote in message
> news:BD934AFF-34D0-45DB-9F30-20172EFBAA64@microsoft.com...
> >I have built a workbook in which I have inserted a formula to tell me
> >whether
> > the contents of a supply bin needs replenishment or not. The formula I
> > used
> > is: =IF(E3>F3,"REPLENISH!","No Action"). Each morning, I run a report to
> > see
> > what parts have been used, which becomes a new sheet in the workbook.
> >
> > Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
> > back through the workbook to count whether that same part needed
> > replenishment on consecutive previous days. If it has, then the latest
> > worksheet will report the number of days that part that part has been in
> > need
> > of replenishment.
> >
> > Can you help me?
>
>
>