I have a small vba code to copy data to another sheet - (data from SampleSheet1 {range(B17:W*) *is obtained from cell AA17} to SampleSheet2 {range(no change from last selected)}
Dim Cval As Variant
Dim Rng1 As Range
Worksheets("SampleSheet1").Activate
Cval =...