Macro to copy and paste info into specific cell

Hi,
Can anyone help me w/ a macro that will take the comments from "Sheet 2" and paste it into the corresponding cell on the "Notes" tab for the specific name and month indicated on "Sheet 2"?

Thank you so much!

Place this macro in the code module for worksheet Sheet2. First fill in the name and month and then the Comments. When you exit the Comments cell, it will be copied to sheet "Notes".

Please Login or Register  to view this content.

Hi Jane. The way it works in the sample file I attached is that the copying of the comments happens automatically when you fill in cell B2 in "Sheet2" and exit the cell. This saves you from having to click a button. If you don't want the copying to happen automatically, then place the following code into a regular module, create your button and assign the macro to it. If you choose to use a button, delete the macro from the worksheet code module otherwise the copying will continue to happen automatically.

Please Login or Register  to view this content.