Not sure if this has been asked before can't seem to find the answer I'm looking for...
I have click buttons in place to copy a range of cells on one worksheet and then paste on another worksheet these work fine with the codes below:
Sub MWeek1()
Worksheets("Malton Weekly Input").Range("A3:K37").Copy
Worksheets("Malton Display").Range("BU12:CE46").PasteSpecial Paste:=xlPasteValues
End Sub
Sub MWeek2()
Worksheets("Malton Weekly Input").Range("A40:K74").Copy
Worksheets("Malton Display").Range("BU12:CE46").PasteSpecial Paste:=xlPasteValues
End Sub
I have buttons for Weeks 1 through to 5.
What I'm now wanting to achieve is to mirror or link the cells after the button has been clicked so that both worksheets are updated. So if the user clicks the Week 1 button on the display sheet, the values from the Week 1 range on the weekly input sheet are copied & pasted across, and then if the user was to add anything on the display sheet it would automatically update the week 1 range on the weekly input sheet.
The idea being that the user can switch back and forth between weeks using the command buttons & update them without leaving the display sheet.
Apologies if I haven't made this clear enough will provide more info if needed.