Please Help

[Cybernut39]

I have two groups of cells on a work sheet G10:M42 and O10:U42 in group G10:M42 I have a drop down combobox in each cell that contain names. I will not get into all the details but when you select a name in the cell it populates a number in a cell in the other group ( ex: if a name was selected in G10 it would populate a number in O10 select a name in H10 it would populate a number in P10 etc.) I would like to have all the names in a list and as a name is selected in group G10:M42 it would add the corresponding numbers from group O10:U42 in the colum next to the list. Im new to this so Im sure I did not explain it well so feel free to email me at ralph@hvc.rr.com and thanks for any help.

 

[Zack Barresse]

welcome to the board!

a little hard to follow. could you post w/ Colo's HTML Maker (bottom of page) for us visual people

 

[RichardS]

How do the cells O10:U42 know what number to use when you select the name in the first group of cells? There must be some logic, or a table, something somewhere to tell Excel what to populate the secondary cells with? If so, that is the source of your data for your list. Or is it a random number?

Richard

 

[Cybernut39]

here is part of it, thanks

testtest.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
7							Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
8							7/7/2004	7/8/2004	7/9/2004	7/10/2004	7/11/2004	7/12/2004	7/13/2004
9		Start	End																			Sum
10		12:00AM	8:00AM				Dawn								8	0	0	0	0	0	0	8.00
11							Joe								8	0	0	0	0	0	0	8.00
12							Joe								8	0	0	0	0	0	0	8.00
13															0	0	0	0	0	0	0	0.00
Week 1

 

[Zack Barresse]

i don't think i'm seeing what you are asking to be accomplished here. from what i can surmise of your question, you have answered it already from your calculation in column V.

from what you have posted, what is it that you desire as the outcome? if it would help, could you post a mock set-up of the outcome?

 

[Cybernut39]

Im sorry Im not verry good at explaining things, under the program that i have posted i will have the names that are in the cells so where I have dawn in my list under the program i want it now to have 8 in the sell next to her name. if i would also put her name in I10 I want it to take the number from Q:10 and add it to 8 result 16 the numbers in O10:U13 may be different depending on the time I put in.

 

[Zack Barresse]

you know, maybe i don't get it. but what it sounds like you want is alternating columns?? name, #, name, #?? and if this is the case, why don't you just cut/paste your columns? very easy with excel xp.

right click column O -> cut, right click column H -> Insert cut columns (not paste), and so-on and so-forth. this should move your references also.

post back w/ further info if needed please.