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

No comments:

Post a Comment