Copying The Values To The Other Page

Useful Macros – 11

Copying The Chosen Values To The Other Sheet

            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
 sh2.Cells(k, 3).Font.ColorIndex = 3
Next