Data Validation and IF Statement

[dah]

Hi,

I have an Excel spreadsheet that handles an expense report.

I set up Data Validation in Column A to pull entries from a list:

AutoFill
Self
Full Service.

This works fine.

I would like to use data validation or an IF statement in Column B s
that when "AutoFill" is selected in Column A, another list appears i
Column B for the user to select entries from say:

BP
Speedway
Shell

I only want the list in Column B to come up if "AutoFill" is selecte
in Column A.

Is this possible?

Thanks,
Debbi

Attachment filename: expense.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=57881

 

[Frank Kabel]

Hi
see: http://www.contextures.com/xlDataVal02.html