R
ronnomad
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
333 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
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
333 is the column with item numbers, G26 is thespecific 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