Validation I Hope
 

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.



--
Becky

Validation I Hope
 

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.

"MarsBars" wrote:

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.



--
Becky