Issue to button and unable to copy

[HuaminChen]

Hi,
Can you see file below, and advise how I can add codes (as the clicked event) to the button within Ledger sheet?
https://1drv.ms/x/s!Ai8CrEskdewXngRR6DYl8WCGYsQY


It seems also the below codes do not copy the values of cells properly. Any idea?

    Worksheets("Ledger").Range("L11:L21").Copy
    Worksheets("Ledger").Range("M11:M21").PasteSpecial Paste:=xlPasteFormulas

 

[Fluff]

To copy values only try

Worksheets("Ledger").Range("M11:M21").value=Worksheets("Ledger").Range("L11:L21").value

Is your button a Forms Control button, or an ActiveX one?