Can anyone please help me with my question regarding excel? Please see the details below?

Question

I have two columns in my excel sheet. First column is for the version name and the 2nd column is for version name+version number. The version name can have the value A or B or C. The version number can have the value 1 or 2 or 3.

The requirement is, as soon as I pick the version name from the list in any cell in the first column, the 2nd column should create a list dynamically based on the value selected in the first column. For instance, if I select B from the list for the first column, the possible values for the 2nd column in that row should be B1 or B2 or B3.

Answer 1

Pay Attension here, I am going to show you how you can do it in Excel, After all I am the VBAXLMan
You will need to focus with me here, we have somethings to do first.
ONE)
Type your (table of values) in the same sheet(Say Sheet1) in another cells, say starting from H1
in H1, I1 and J1 type A, B and C, respectively
in H2, I2 and J2 type A1, B1 and C1
in H3, I3 and J3 type A2, B2 and C2 and do the same for H4, I4 and J4
TWO)
Assuming you want to put one of these values (A, B or C) in cell B1 and want the list to be populated in C1, Do this:
Go to Insert > Name > Define
and paste this in the "Refers to" box
=OFFSET( Sheet1!$H$1,1,MATCH( Sheet1!$D$1,Sheet1!$H$1:$J$1,0 ) -1,3)
type a name for this "Name" (make it VBAXLMan) and click "Add"
THREE)
Now, doing a Data > Validation in cell C1 with a list that is named "VBAXLMan" will do your trick
FOUR)
Change the value in cell B1 into A, B or C and watch the list of (Data > Validation) changing.

Mail me anything you need about this

Trust me, I am doing this since 1997, After all I am the VBAXLMan

Answer 2

Go to data/autofilter click on the arrow on column a to select what you want, column b will now show the possible values of what you have chosen