Macro to update a cell value to match another cell within the same workbook

[lawi227]

I am looking to create a macro button. I have no experience with macros, etc.

I have a cell (N3) in Sheet 1 (called "16-17M"). I need this value to match a cell (B3) in Sheet 2 (called "Goal Tracking").

I have some conditional formatting that tells me when cell N3 does not match B3. I would like to have a button right next to cell N3 that I can click on and it will automatically update that number.

Note: Cell N3 is used in multiple formulas (such as VLOOKUP) and that is why this cell has to be text and I cannot reference or use a formula.

 

[lawi227]

The macro now works. It was updating the wrong cell and I didn't notice. So I can get the macro to run, but I cannot get the button to run the macro. I must not have assigned the macro correctly.. I'm new to all these buttons and macros so sorry for the trouble. Any suggestions?

 

[j_unsuitable]

If you got the Macro going it should be really easy to assign it to a button, actually you really just have to right click it, pick assign macro, a list of all your macros should pop up, pick one, hit "ok", click anywhere but on the button, then the next time you push it, the macro should run.
Here is another description:

Assigning Macro to Button in Excel | Add Excel Button to Run Macro

 

[lawi227]

If you got the Macro going it should be really easy to assign it to a button, actually you really just have to right click it, pick assign macro, a list of all your macros should pop up, pick one, hit "ok", click anywhere but on the button, then the next time you push it, the macro should run.
Here is another description:

Assigning Macro to Button in Excel | Add Excel Button to Run Macro

I got it to work - just saved and closed out of the file and re-opened it.

Thanks so much!!