|Hi, my workbook has got a "Master" sheet and other sub-category sheet, I would like to write a macro code, once I put in value in colum 10 in "Master" sheet, the entire row will be moved to the corespondent worksheet, eg, if I type in "Apple" in cell in colum 10 then the entire roll will be moved to first blank row of "Apple" worksheet.I wrote a Macro, however, it doesn't work. |
Any help would be appriciated.
My macro code was:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 And Target.Cells.Count = 1 Then
If Target.Value ="Apple" Then