Hi all,
I am trying to write some VBA to copy and paste a specific range in the active sheet to another sheet again to a specific range, but as values (as I have formatting rules set up in the destination).

Range for copy: J4:J34
Sheet copying from: "U4Brief1"

Range to paste to B4:B34
Sheet pasting to: "U4 Tracker"

I want to assign this to a button for colleagues to click to copy the data.

Any advice greatly appreciated.

Thanks

Luke