G
gam33040
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
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