I have a workbook with 11 sheets. The first ten break down requests from
individual production areas for materials by item, quantitiy and date
required. The last sheet is a summation of all open requests. As each
request is fully or partially fulfilled, the column containing the requested
amount of that particular line is reduced until it reaches zero. If there
are multiple requests for the same item from one area (or multiple
areas...although each area uses specific materials, that are a few that
overlap) all are are individual lines.

I can obtain the total amount of each item requested on the last sheet using
a SUMIF "SUMIF(Area1!$D$2:$D$333,G26,Area1!$O$2:$O$333 )" calculation, where
Area1 is the first sheet, D2:D333 is the column with item numbers, G26 is the
specific item for this particular line and O2:O333 is the column with the
quantities still needed. (and I apologize if I have made this too basic).

In column P is the requested delivery date for the item. What I would like
to see on the summation is the earliest date for which there is still a
delivery due. This way I can quickly see past due or imminent due dates
without having to look at each area's sheet.

Thanks,

Ron

Ron,

I haven't looked at your situation in detail, but I think you need to put all the data in a
single table (single sheet). Doing all kinds of analysis is much easier then. Read "Data
across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm. Consider it
carefully.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"ronnomad" wrote in message
...
I have a workbook with 11 sheets. The first ten break down requests from
individual production areas for materials by item, quantitiy and date
required. The last sheet is a summation of all open requests. As each
request is fully or partially fulfilled, the column containing the requested
amount of that particular line is reduced until it reaches zero. If there
are multiple requests for the same item from one area (or multiple
areas...although each area uses specific materials, that are a few that
overlap) all are are individual lines.

I can obtain the total amount of each item requested on the last sheet using
a SUMIF "SUMIF(Area1!$D$2:$D$333,G26,Area1!$O$2:$O$333 )" calculation, where
Area1 is the first sheet, D2:D333 is the column with item numbers, G26 is the
specific item for this particular line and O2:O333 is the column with the
quantities still needed. (and I apologize if I have made this too basic).

In column P is the requested delivery date for the item. What I would like
to see on the summation is the earliest date for which there is still a
delivery due. This way I can quickly see past due or imminent due dates
without having to look at each area's sheet.

Thanks,

Ron

Earl,

Wish I could but business considerations (and the size of the individual
sheets) negates that possibility.

Thanks,

Ron

"Earl Kiosterud" wrote:

Ron,

I haven't looked at your situation in detail, but I think you need to put all the data in a
single table (single sheet). Doing all kinds of analysis is much easier then. Read "Data
across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm. Consider it
carefully.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"ronnomad" wrote in message
...
I have a workbook with 11 sheets. The first ten break down requests from
individual production areas for materials by item, quantitiy and date
required. The last sheet is a summation of all open requests. As each
request is fully or partially fulfilled, the column containing the requested
amount of that particular line is reduced until it reaches zero. If there
are multiple requests for the same item from one area (or multiple
areas...although each area uses specific materials, that are a few that
overlap) all are are individual lines.

I can obtain the total amount of each item requested on the last sheet using
a SUMIF "SUMIF(Area1!$D$2:$D$333,G26,Area1!$O$2:$O$333 )" calculation, where
Area1 is the first sheet, D2:D333 is the column with item numbers, G26 is the
specific item for this particular line and O2:O333 is the column with the
quantities still needed. (and I apologize if I have made this too basic).

In column P is the requested delivery date for the item. What I would like
to see on the summation is the earliest date for which there is still a
delivery due. This way I can quickly see past due or imminent due dates
without having to look at each area's sheet.

Thanks,

Ron