Hi,

I am totally NEW to macro (VBA or Excel).

I wanted to know how to move specific data from a worksheet to another worksheet.

For example, Worksheet1 contain below data:
Order# Item
------------------
10001 Pencil
20004 Catridge
10006 Ball Pen
10003 Pencil Lead
20006 Paper
10005 Rubber

The Order# is the raw data from users. I want to move the data that have Order# begins with 1 to a new worksheet (Worksheet2) and then Order# begins with 2 to another worksheet (Worksheet3).

Can someone help?