ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY (https://www.excelbanter.com/excel-discussion-misc-queries/252956-sub-category-using-data-validation-alrdy-usng-dv-category.html)

sameer

A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY
 
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


Stefi[_2_]

A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY
 
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

Roger Govier[_3_]

A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY
 
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





All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com