Validation I Hope

[MarsBars]

Data entry project - keeps changing & I am not as up to speed in Excel 2007

Select Data for Major Category - i.e. Appliances, Furniture

Sub Category -

Appliances would not have a Sub Category - Return value of N/A
Furniture has 3 Sub Categories - or N/A

Finally Item is linked to Major Category if Sub Category is N/A

BUt if Sub Category is not NA - data validation from list

If I have confused you - sorry.

 

[JLatham]

See if there isn't something here
http://www.contextures.com/xlDataVal02.html
that will help you out. If that's not exactly what you need, check some of
her other dependent lists solutions. Hope this gets you going in the right
direction.