Forum Discussion
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 |
1 Reply
Please find attachment.
