Hi all,

I have already used data validation tool to set up a category column but i
wish to set up sub categories within these categories, i mean when i choose a
category, the sub category column should give only those related to the
category chosen.

thanks

On Jan 11, 12:27*pm, sameer wrote:
Hi all,

I have already used data validation tool to set up a category column but i
wish to set up sub categories within these categories, i mean when i choose a
category, the sub category column should give only those related to the
category chosen.

thanks

See e.g. http://www.contextures.com/xlDataVal08.html
Regards,
Stefi

Hi

Take a look here
http://www.contextures.com/xlDataVal15.html

--
Regards
Roger Govier

"sameer" wrote in message
...
Hi all,

I have already used data validation tool to set up a category column but i
wish to set up sub categories within these categories, i mean when i
choose a
category, the sub category column should give only those related to the
category chosen.

thanks


__________ Information from ESET Smart Security, version of virus
signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com