Data Validation and IF Statement

  • Thread starter Thread starter dah
  • Start date Start date
D

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
 
Back
Top