Jan 31 2023 01:56 AM - edited Jan 31 2023 02:47 AM
Hi all,
I would like to know how to create a sub-drop-down list based on the main drop-down list.
What I want is when I select "a" in cell E3, there will be selection of "1, 2, 3" in cell F3. Is there any method to do so without transposing the data?
Jan 31 2023 04:26 AM
SolutionJan 31 2023 04:31 PM