Hi all,

Does anyone know how to create two list in different cells based on the
selection of the first list?

For example, i have one drop down list with these items: A, B ,C, D.

If 'A' is chosen, then i have two seperate cells that are dependent on the
selection of 'A' with their own list of values. 'A' has values of "A1, A2."

And 'A1' has list of 1,2,3,4
'A2' has list of 5,6,7,8.


I hope someone can help. Thanks in advance.