INVENTORY CONTROL BY SPECIFIC ITEM
 

I'm trying to figure out the following problem: (using Excel 2003)
I have two different dates for the specific length of time that a particular
function will take place, one column is for the IN DATE the other column is
for the OUT DATE, on those specific dates there are different materials that
will be used during those dates. Lets said I have two items, one called "A"
and another "B" those items will be used from Jan. 1 to Jan. 22 for item A
(for quantity of 1) and Jan. 2 to Jan. 4 for item B (for quantity of 5), here
is my problem:

How can I show the diffefferent items being used (not by name but quantity)
throughout the days that the item are being used. Each item will have its
own different table. example:

item: A jan.1 jan.2 jan.3 jan. 4 ....jan
22..... jan. 31
function name 1 1 1 1
1


item: B jan.1 jan.2 jan.3 jan. 4.........
jan. 31
function name 5 5 5


Any help will be appreciated

INVENTORY CONTROL BY SPECIFIC ITEM
 

Quantity in a2
In date is in cell a3
Out date is in cell a4
Dates are in b1:b10

In B2
=IF(and(B1=$A$3,B1<=$A$4),$A$2,"")

Copy across to B10.

You could copy this entire segment (A1:B10) to form your different table for
different items. Dates could also be dragged/copied to the right.

I will make note that if you have access to the program, Microsoft Project
could show this much better. But I understand if you have a specific reason
for using Excel.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gam33040" wrote:

I'm trying to figure out the following problem: (using Excel 2003)
I have two different dates for the specific length of time that a particular
function will take place, one column is for the IN DATE the other column is
for the OUT DATE, on those specific dates there are different materials that
will be used during those dates. Lets said I have two items, one called "A"
and another "B" those items will be used from Jan. 1 to Jan. 22 for item A
(for quantity of 1) and Jan. 2 to Jan. 4 for item B (for quantity of 5), here
is my problem:

How can I show the diffefferent items being used (not by name but quantity)
throughout the days that the item are being used. Each item will have its
own different table. example:

item: A jan.1 jan.2 jan.3 jan. 4 ....jan
22..... jan. 31
function name 1 1 1 1
1


item: B jan.1 jan.2 jan.3 jan. 4.........
jan. 31
function name 5 5 5


Any help will be appreciated

INVENTORY CONTROL BY SPECIFIC ITEM
 

THANKS LUKE M,

THIS IS EXACTLY WHAT I WAS LOOKING FOR. I APPRECIATE YOUR FAST RESPONSE.
KEEP UP THE GREAT WORK!!!!
--
gam33040


"Luke M" wrote:

Quantity in a2
In date is in cell a3
Out date is in cell a4
Dates are in b1:b10

In B2
=IF(and(B1=$A$3,B1<=$A$4),$A$2,"")

Copy across to B10.

You could copy this entire segment (A1:B10) to form your different table for
different items. Dates could also be dragged/copied to the right.

I will make note that if you have access to the program, Microsoft Project
could show this much better. But I understand if you have a specific reason
for using Excel.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gam33040" wrote:

I'm trying to figure out the following problem: (using Excel 2003)
I have two different dates for the specific length of time that a particular
function will take place, one column is for the IN DATE the other column is
for the OUT DATE, on those specific dates there are different materials that
will be used during those dates. Lets said I have two items, one called "A"
and another "B" those items will be used from Jan. 1 to Jan. 22 for item A
(for quantity of 1) and Jan. 2 to Jan. 4 for item B (for quantity of 5), here
is my problem:

How can I show the diffefferent items being used (not by name but quantity)
throughout the days that the item are being used. Each item will have its
own different table. example:

item: A jan.1 jan.2 jan.3 jan. 4 ....jan
22..... jan. 31
function name 1 1 1 1
1


item: B jan.1 jan.2 jan.3 jan. 4.........
jan. 31
function name 5 5 5


Any help will be appreciated