VB Help: Double Clicking a cell and different cells pdating

Hey everyone,

I am trying to write a VB code that when I double click on a particular cell, two cells on a different tab update to the column heading and row heading. For example, in the data below, if I double click the cell in D3, I should get the cell "B1" in another tab to update to "b" and the cell underneath it, "B2" to update to "2".

PHP Code: 

 Sheet1                                                                                       Sheet2
 
            A          B           C            D           E           F                              A            B         C
        1                           1            2            3          4                          1   Letter:     b
        2             a                                                                               2   Number:   2
        3             b                                                                               3
        4             c
        5 
        6 


Any help would be very useful. Please keep in mind that I have never used this help forum before, so any advice on how to use this forum better would be helpful as well. Thank you all!