I would like to have a dropdown list based on a dropdown list from another column.
EXAMPLE:
Column A = Main Category (Accounting, Collections, Payables)
Column B=Sub Category (If Column A is Accounting I would like Column B to only show drop down options (GL, Transfer, Set up, Close) associated with Accounting. If Column A is Collections I would like Column B to only show drop down options(Past Due, Retention, Not yet Due) associated with Collections.