Drop down list of a series of numbers based on cell value

[SamPer]

Hello,

I am hoping to create a drop down list that automatically updates based on a single cell's value.

For instance if cell A1 = 4, the drop down list options are whole numbers: 1,2,3,4. If cell A1 is changed to 10, the drop down list options are changed to: 1,2,3,4,5,6,7,8,9,10.

Any help is appreciated. TIA!

 

[Peter_SSs]

Welcome to the MrExcel board!

Use the SEQUENCE function like I have in D1 (can be anywhere and the column can then be hidden) and set up the Data Validation as shown for B1

21 08 28.xlsm
	A	B	C	D
1	4			1
2				2
3				3
4				4
5
6
7
Sheet2 (3)

Cell Formulas
Range	Formula
D1:D4	D1	=SEQUENCE(A1)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B1	List	=D1#