Help find the right code to create musical scale generator in excel

[Tgv10]

Hello.
I need help choosing the type of VBA code to use to create a musical scale generator in Excel. I want to define the musical notes and the intervals between the notes and I want Excel to automatically generate the notes using the first note and the intervals of that scale. For example I want to define these rules:1-T=C (C, C#, D, D#, E ...)2-musical intervals (T, 2m, 2M, 3m, 3M...), and the 3-intervals of the "Major" scale ( T, 2M, 3M)I ask for the C Major scale and the result will be (C, D, E)Basically I want to define the cases in relation to the intervals between the notes and this way I don't need to create 12 cases but only 1. What's the best way to do this? Should I go through the "arrays"? Thanks.

 

[C Moore]

You may have to use index,match instead of xlookup, not sure the excel version it was added.

scratchbook excel testing.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Sharps	Flats	Step		Note	Major step			Major	Sharps	Flats
2	C	C	0		1	0			Scale	F	Bb
3	C#	Db	0.5		2	1		Notes	1	F	Bb
4	D	D	1		3	1			2	G	C
5	D#	Eb	1.5		4	0.5			3	A	D
6	E	E	2		5	1			4	A#	Eb
7	F	F	2.5		6	1			5	C	F
8	F#	Gb	3		7	1			6	D	G
9	G	G	3.5		8	1			7	E	A
10	G#	Ab	4						8	F#	B
11	A	A	4.5
12	A#	Bb	5
13	B	B	5.5
14	C	C	6
15	C#	Db	6.5
16	D	D	7
17	D#	Eb	7.5
18	E	E	8
19	F	F	8.5
20	F#	Gb	9
21	G	G	9.5
22	G#	Ab	10
23	A	A	10.5
24	A#	Bb	11
25	B	B	11.5
26	C	C	12
Sheet26

Cell Formulas
Range	Formula
J3:K3	J3	=J2
J4:J10	J4	=XLOOKUP( XLOOKUP(J3,Table36[Sharps],Table36[Step],,0,1)+ XLOOKUP(I4,Table37[Note],Table37[Major step],,0),Table36[Step],Table36[Sharps],,0)
K4:K10	K4	=XLOOKUP( XLOOKUP(K3,Table36[Flats],Table36[Step],,0,1)+ XLOOKUP(I4,Table37[Note],Table37[Major step],,0),Table36[Step],Table36[Flats],,0)

Cells with Data Validation
Cell	Allow	Criteria
J2	List	=$A$2:$A$13
K2	List	=$B$2:$B$13