Feb 01 2018
02:43 PM
- last edited on
Jul 25 2018
10:56 AM
by
TechCommunityAP
Feb 01 2018
02:43 PM
- last edited on
Jul 25 2018
10:56 AM
by
TechCommunityAP
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 |