0
votes

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.

Please, never ever post your code as an image. Edit your question and add the relevant code parts, what errors are you getting, input and expected output - Foxfire And Burns And Burns
My apologies didn't realise the image would be an issue, have edited the question with the code in place. In terms of errors I haven't had any, as I don't know what I need to add to achieve my aim. Thanks - ALanders