1
2
1
2
1
2
4
3 5 6
select the column
select data validation
select data validation
1 2
select List
Click here and go to Sheet2 to select your list
After you select your list
Click OK
Go to C2
Go to D2
Insert that formula
You can improve the formula to avoid the appearance of errors. Add this
Select range A1 to D2
We finished this macro Now, let's give it a button
1 2
1
2
1
2
3
This is done