Need some help. How to put any key (i.e, A, Bm, F#, etc.) in a designated cell on the main tab, then, I want it to go another sheet where I have all notes associated. See below.
Entered "C", on main tab, then it would look at (column A, Row 1)and pull entries in columns B-H, row 1 and list them in the designated cells on the main tab.
| C |
C |
D |
E |
F |
G |
A |
B |
| G |
A |
B |
C |
D |
E |
F |
G |
| D |
D |
E |
F# |
G |
A |
B |
C# |
| A |
A |
B |
C# |
D |
E |
F# |
G# |
| E |
E |
F# |
G |
A |
B |
C# |
D# |
| B |
B |
C# |
D# |
E |
F# |
G# |
A# |
| F# |
F# |
G# |
A# |
B |
C# |
D# |
E# |
| Db |
Db |
Eb |
F |
Gb |
Ab |
Bb |
C |
| Ab |
Ab |
Bb |
C |
Db |
Eb |
F |
G |
| Eb |
Eb |
F |
G |
Ab |
Bb |
C |
D |
| Bb |
Bb |
C |
D |
Eb |
F |
G |
A |
| F |
F |
G |
A |
Bb |
C |
Dm |
Edim |
| Cm |
C |
D |
Eb |
F |
G |
Ab |
Bb |
| Gm |
G |
A |
Bb |
C |
D |
Eb |
F |
| Dm |
D |
E |
F |
G |
A |
Bb |
C |
| Am |
A |
B |
C |
D |
E |
F |
G |
| Em |
E |
F# |
G |
A |
B |
C |
D |
| Bm |
B |
C# |
D |
E |
F# |
G |
A |
| F#m |
F# |
G# |
A |
B |
C# |
D |
E |
| C#m |
C# |
D# |
E |
F# |
G# |
A |
B |
| G#m |
G# |
A# |
B |
C# |
D# |
E |
F# |
| Ebm |
Eb |
F |
Gb |
Ab |
Bb |
Cb |
Db |
| Bbm |
Bb |
C |
Db |
Eb |
F |
Gb |
Ab |
| Fm |
F |
Gb |
Ab |
Bb |
C |
Db |
Eb |
