Ok i am new to Excel and to these forums but here i go.
Instead of trying to describe what i need i will just show
it. my fire is still a massive work in progress but what it depicts is.
I am making a spread sheet from a list
of information me and some friends are compiling for a game we play.
As you can see,
The A Column is the slot the item goes in.
The B Column is the items name.
The C to X columns is the information on the item. still being expanded on.
What i am trying to figure out is. I
need to add drop down lists in the B Column for each slot so i can add new items to the list. when i select each new item in
the list it needs to update the stats in the C > X column. So in essence if i say have 3 items in the B2 cell. if i
change from item 1 to item 2. all the stats in cell C2 > X2 need to change to what item 2 has listed. then back again
when i change back.
The chart still needs to be readable with the =SUM command i have in the totals line. thats
why i don't have say. each slot on its own page with each item listed per column.
The drop down menu for the B
Cells needs to be able to be updated with ease and the chart needs to be kept clean. most likely i will need to add more
sheets foe each slot or something.
I just do not know how to make a drop down list populate all those cells with
the saved information. still being new to excel (have been playing at it for less than a week now) i don't know all the
advanced commands so forgive me if there is a big button on the program that shows how to do this.
would be better to ask those who have been using this longer than me so i can do this right. rather than messing with it and
ruining my work.
So to sum it up. i need to add a drop down menu in each cell in the B column. each drop down
needs to have easy access to add new items and take old ones out. and it needs to show the entered information correctly in
the C to X columns.
Hope this is doable.