Remove data to another sheet

Microsoft Excel 2000/visual basic for ap...
August 15, 2009 at 06:18:54
Specs: Windows Vista
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
ActiveSheet.Range("A1").End(xlDown).Offset(1, 0).Select

End If
End If
End Sub

See More: Remove data to another sheet

Report •

August 15, 2009 at 22:32:19
This post should be in the "Office Software" forum. Link on the right.

Report •
Related Solutions

Ask Question