noobie
11-21-2006, 06:07 PM
:hi: all,
before posting this thread, i check alot on this forum. But apparently, none was so similar to what i wanted. So I would appreciate if anyone could provide any suggestions! : pray2:
I need a macro which sort my rows
- only when the data is entered from til column K (starts at column A).
- based on the first two columns.
- based on worksheet change
Private Sub Worksheet_Change(ByVal Target As Range)
Columns("A:B").Sort _
Key1:=Range("A:B"), Order1:=xlAscending, Header:=xlYes
End Sub
so after this is what i have modified! Pls help! Thanks everyone!
before posting this thread, i check alot on this forum. But apparently, none was so similar to what i wanted. So I would appreciate if anyone could provide any suggestions! : pray2:
I need a macro which sort my rows
- only when the data is entered from til column K (starts at column A).
- based on the first two columns.
- based on worksheet change
Private Sub Worksheet_Change(ByVal Target As Range)
Columns("A:B").Sort _
Key1:=Range("A:B"), Order1:=xlAscending, Header:=xlYes
End Sub
so after this is what i have modified! Pls help! Thanks everyone!