Code to move data from an entry table to a historical table by date.

In the attachment you will see an example of what I am trying to accomplish. What I am trying to do is find VBA code that is either specific to this worksheet or in a macro. When the sheet is opened I enter a date in B2. I then enter data into A7, B7, and C7. What I would like to happen is when the data is entered into A7, B7, and C7 the sheet goes and finds the same date that I entered in B2 and copies that data from A7, B7, and C7 into F7, G7, and H7.


Thank you and any help given is greatly appreciated.

Berlan,

Thank you very much for your help. This is a perfect solution to my problem. You have saved me a ton of time.