hi all ,
i come to here because mrexcel site close for maintenance.
mr jindon , have help me on following code.
Sub Macro_______________jindon_fill_grouping_to_group_data() On Error Resume Next With Range("e1", Range("e" & Rows.Count).End(xlUp)).Offset(, -1).SpecialCells(4) .FormulaR1C1 = "=rc[1]" .Value = .Value End With End Sub
Hope some one can help me.
paul yeo
Bookmarks