q

null null
Occasional Visitor

q

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

Re: q

Please find attachment.