vba to Cut data from master and paste into next newsheet depends upon value of a col

[manilara]

Dear sir

goodmorning



I want vba code to Cut data from master and paste into newsheet & rename it its depends upon value of a col X:X in master sheet value of text barcode and cancelled:

I have set of data in master sheet In the column x:X header status have multiple text values but i want cut values only barcode and cancelled only move into newsheet with rename of sheet called "barcode and cancelled "

pls find the attachment you may understand

 

[My Aswer Is This]

Can you please explain this better?
One example is col x:x