Ok I have revised this worksheet. What I am trying to get at is this:
I have seperate columns on my spread,
COL A = MOD #
COL B = PO#
COL E = SIZES
COL F = MON (production, qty)
COL G - K = TUE - FRI (production qty)
I HAVE A LIST OF PO #'S I WILL BE USING FOR THE WEEK AT THE BOTTOM, A
WELL AS A LIST OF MODULE NUMBERS LISTED BELOW
The problem I have is we input multiple PO's and multiple sizes int
diff modules by day, this makes it time consuming to enter and track.
Like EX say i input 23 pcs in module 1A for size Small, and 45 pcs i
module 7A for size Small, then in the PO BOX and the COL for Size smal
it was list both Modules 1A,7A automaticly. Just by inputting into exce
to search for the MOD # that only corrosponds with a certain PO #.
I belive it would also be possible to do the same with the actua
production
qty's
The attachment is small and will help to see the picture, any help yo
guys can give me is greatly appreciated, I am trying to figure out ho
I could do this on my own, but keep running into problems with th
functions. thanks.
Dustin Miller

+-------------------------------------------------------------------

+-------------------------------------------------------------------