C
chizgiz
Hi there,
I hope I put this so its easy to understand so here goes.
I want to make a drop down list (easy, Done)
But this is the hard part I cant work out. I want to be able to have other
values attached to the drop down list that appear in other cells. eg. below.
In Cell A1 is the drop down list. And I want to add values to the items in
that list that show up in the cells C1-C8 depending on what it makes.
eg.
in the drop down list say
wooden box
wooden barral
So for wooden box I want to have in C1 2(for the number of planks needed
in C2 I want 20 for nails
in C3 1 for a handle
But when I choose the barral from the drop down list I want it to say
10 in C1 for planks
50 in C2 for nails
0 in C3 for the handle
I know it can be done as I have seen a sheet like it but its protected with
a password and I dont know whos it is.
So can anyone explane how to do it, if needed I can try and explane better
with a pick or put the sheep up so you can see it.
I hope I put this so its easy to understand so here goes.
I want to make a drop down list (easy, Done)
But this is the hard part I cant work out. I want to be able to have other
values attached to the drop down list that appear in other cells. eg. below.
In Cell A1 is the drop down list. And I want to add values to the items in
that list that show up in the cells C1-C8 depending on what it makes.
eg.
in the drop down list say
wooden box
wooden barral
So for wooden box I want to have in C1 2(for the number of planks needed
in C2 I want 20 for nails
in C3 1 for a handle
But when I choose the barral from the drop down list I want it to say
10 in C1 for planks
50 in C2 for nails
0 in C3 for the handle
I know it can be done as I have seen a sheet like it but its protected with
a password and I dont know whos it is.
So can anyone explane how to do it, if needed I can try and explane better
with a pick or put the sheep up so you can see it.