C
changetires
I am needing some help with this, so here it goes.....I have a product
sheet that contains a product name, cycle times and bdp.
On my data sheet I need to have these different parameters imported to
the data sheet except for product name. I will pick a product from a
product pull down list that I created using name>define and data
validation.
So in cell B5 I will have a product pull list, when I pick a certain
product I will need the different cycle times to be imported to the
sheet in cells D5, E5, F5, G5, H5, I5, and J5 and bdp to be imported to
cell L5. Now after entering all the data I will have to move down to
the next product and pick it from the pull down list and have the same
thing happen on the next line. If I can get something that will get me
that far I am gonna have to do some conditional formatting cause I will
want some cells to change to red when the actual cycle time becomes
less than a set standard for each cycle time.
Can this be done?
ED
sheet that contains a product name, cycle times and bdp.
On my data sheet I need to have these different parameters imported to
the data sheet except for product name. I will pick a product from a
product pull down list that I created using name>define and data
validation.
So in cell B5 I will have a product pull list, when I pick a certain
product I will need the different cycle times to be imported to the
sheet in cells D5, E5, F5, G5, H5, I5, and J5 and bdp to be imported to
cell L5. Now after entering all the data I will have to move down to
the next product and pick it from the pull down list and have the same
thing happen on the next line. If I can get something that will get me
that far I am gonna have to do some conditional formatting cause I will
want some cells to change to red when the actual cycle time becomes
less than a set standard for each cycle time.
Can this be done?
ED