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.