Copy Range of Data base on Cell Value

enter image description herecan anyone pls help.

I hv a list with Column A to C, Row unknown depends on condition.

Column B contains either "A" "B" "C"

I would a VBA code to copy all data from column a - c when Column B is "A" to sheet 1 and to sheet 2 when column B is "B" and so on, I know its using the For i = 1 to .End(xlUp).Offset(0), but then what should I do, I tried but wasn't working at all for me.

can any one pls help

Recent Questions...