Hi,
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
10006 Ball Pen
10003 Pencil Lead
20004 Catridge
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).
Is this feasbile to do in Excel?
Bookmarks