Linking data in excel

Microsoft Microsoft office excel 2007 ac...
August 6, 2010 at 04:36:47
Specs: Windows XP
Hi there - how do i link data in excel? My problem is that I want to assign attributes to names in a drop down list. So if i chose x in the drop down list, then attributes a,b,c will appear in the next column. and when i chose y in the drop down list, then attributes d,e,f will appear in the next column and so on... can anyone help me please?

See More: Linking data in excel

Report •

August 6, 2010 at 08:08:52
Are you asking about Dependent Validation Lists?

A pretty good explanation can be found here:

I like that explanation because it also explains how excel automatically deals with Named Ranges that have spaces in them.

If you Google "Dependent Validation Lists" you'll get lots of other hits.

Report •

August 11, 2010 at 06:21:21

Please point out the part of the OP's question that made you think that this was an Access related question.

Maybe I missed it.

I will assume - for now - that this was not just an attempt to get your web site mentioned in a Help forum.

Office Forum Moderator

Report •

Related Solutions

Ask Question