Copy data into another sheet

[joyce_88]

Hi,

I am having problem with transfering the data into another sheet. I have the code on how to transfer the data into another sheet if the column B is in number. However, I want my code to transfer the data into another sheet if the column B is in words. For example, the coulmn B is in "machine 1" and "machine 2". I have attached the file. Can anyone help me please? Thanks

[carddards]

As long as column B has 'Machine' in it, you want it copied to Sheet2?
Row after row or?

Could you elaborate?

[joyce_88]

No.I want it to classify accordingly to the machine number in another sheet. For example,

Column A Column B
Mary machine 1
Mary machine 1
Mary machine 1
Mary machine 2
Mary machine 2
Mary machine 2

[carddards]

So you don't want those without 'Machine' to be copied right?

[joyce_88]

I want those with machine to be copied into another sheet.

[carddards]

Try:

Please Login or Register  to view this content.

[joyce_88]

Thanks It works.

[carddards]

Glad I helped. =)