Useful Macros – 11
Copying The Chosen Values To The Other Page
This template is similar to the example in previous tutorial (Useful Macros-10).
Difference between two example; chosen data are just copied (data aren't cut) in this template.
Also in this template , font color of the data in the Column C was selected red :
"For k = 2 To ActiveSheet.Range("C" & Rows.Count).End(xlUp).Row
"For k = 2 To ActiveSheet.Range("C" & Rows.Count).End(xlUp).Row
sh2.Cells(k, 3).Font.ColorIndex = 3
Next "