each days workbook has different data?If the same part number is replenished
they will be in a different cell on each day?.Each day has a completely
different sized data range?,How is each worksheet named?Give us a couple of
examples of data,say the position of the example part number that did need
replenishing say three days in a row,where is it on the sheet,how is the dta
arranged what does the surrounding data look like?
--
paul
remove nospam for email addy!



"blackgold21" wrote:

WOULD ANYONE ELSE CARE TO TAKE A STAB AT THIS QUESTION--PLEASE??

"blackgold21" wrote:

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" wrote in message
...
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(E3F3,"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?