How to pre select validation
I have 13 categories and each of them has approx ten subcategories.
When you select the category in column A from a drop down validation list I want only that categories subcategories to be available from the column b drop down list. how? |
How to pre select validation
Hi JBW,
Take a look at Debra Dalglesih's site http://www.contextures.com/xlDataVal13.html HTH Martin "JBW" wrote in message ... I have 13 categories and each of them has approx ten subcategories. When you select the category in column A from a drop down validation list I want only that categories subcategories to be available from the column b drop down list. how? |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com