I am needing to have a list populated with data dependant on the value
chosen in another field. Basically when a person chooses a day of the
week I want to have the next field list the times of scheduled events
for them to choose one of. I have looked at the help file for how to
write a macro for the adding or modifying of data validations but the
examples when I put them into the code have errors even when copied and
pasted as they appear. I am confused about how to get this to work. I
would like to avoid using a combo box or other control and would prefer
to have it be in the cell directly. Any help would be appreciated.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile: http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

Do you have a set number of events scheduled each day?
************
Anne Troy
www.OfficeArticles.com

"Warderbrad" wrote
in message ...

I am needing to have a list populated with data dependant on the value
chosen in another field. Basically when a person chooses a day of the
week I want to have the next field list the times of scheduled events
for them to choose one of. I have looked at the help file for how to
write a macro for the adding or modifying of data validations but the
examples when I put them into the code have errors even when copied and
pasted as they appear. I am confused about how to get this to work. I
would like to avoid using a combo box or other control and would prefer
to have it be in the cell directly. Any help would be appreciated.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile:
http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

No, the number of items in a given day is variable based on the
avilability of moderators. I have solved the issue of compiling the
list of times by having a seperate table that uses a Concentate
statement to combine all times from the main table for refrence. So
using that work arround there is only one field for each day to pull
up.

Example of both tables

Sunday: 5-7 pm PST
Sunday: 9-11 pm PST
Monday: 4-6 pm PST

Would result to this in the second table

Sunday: 5-7 pm PST, 9-11 pm PST
Monday: 4-6 pm PST

My thought is if I could put the data from the second table into the
source field of the data validation using the list method, then the
commas would result in different items in the choosable list. However
I am having problems figuing out the syntax for the macro that would
update the validation.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile: http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

I'm not sure why you think you need a macro to do this. Using the same
features as this tutorial, you should be able to get your lookup to come
over:
http://www.officearticles.com/tutori...soft_excel.htm
This describes VLOOKUP using a table (in case the tutorial is a bit more
information than you need):
http://www.officearticles.com/excel/...soft_excel.htm
But...maybe there's something I didn't understand. I've done concatenation
with vlookup, too. You just need to create one record in your lookup table
for every possible scenario, and then have a field that concatenates them.
And your vlookup might look like =vlookup(A1&B1,mytable,3,false)

************
Anne Troy
www.OfficeArticles.com

"Warderbrad" wrote
in message ...

No, the number of items in a given day is variable based on the
avilability of moderators. I have solved the issue of compiling the
list of times by having a seperate table that uses a Concentate
statement to combine all times from the main table for refrence. So
using that work arround there is only one field for each day to pull
up.

Example of both tables

Sunday: 5-7 pm PST
Sunday: 9-11 pm PST
Monday: 4-6 pm PST

Would result to this in the second table

Sunday: 5-7 pm PST, 9-11 pm PST
Monday: 4-6 pm PST

My thought is if I could put the data from the second table into the
source field of the data validation using the list method, then the
commas would result in different items in the choosable list. However
I am having problems figuing out the syntax for the macro that would
update the validation.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile:
http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

the problem is not the lookup funtion, it is supplying the data for the
list in the Data Validation. Since the days do not have activities at
the same times I cannot use one list of values for everything. In the
example if a person wanted to attend on Sunday the drop down list would
have to have the options of 5-7 or 9-11, but if they chose Monday it
would need to have the option of 4-6. It is putting those values into
the data validation list that I am having problems with, not the
looking up of other values once the time and day are known.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile: http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

Maybe this will help:

http://www.contextures.com/xlDataVal02.html

Regards
Rowan

Warderbrad wrote:
the problem is not the lookup funtion, it is supplying the data for the
list in the Data Validation. Since the days do not have activities at
the same times I cannot use one list of values for everything. In the
example if a person wanted to attend on Sunday the drop down list would
have to have the options of 5-7 or 9-11, but if they chose Monday it
would need to have the option of 4-6. It is putting those values into
the data validation list that I am having problems with, not the
looking up of other values once the time and day are known.

Thanks that is exactly what I needed. It worked perfectly.


--
Warderbrad
------------------------------------------------------------------------
Warderbrad's Profile: http://www.excelforum.com/member.php...o&userid=28169
View this thread: http://www.excelforum.com/showthread...hreadid=476969

You're welcome.

Warderbrad wrote:
Thanks that is exactly what I needed. It worked perfectly.