sort ParrNumbers in column A that has some "strike-through" values

[William Poh Ben]

Hi EXCEL expert,

Is there a VBA code where I can sort, say, column A of Part Numbers t
have the "strike-through" values appear first, then follow by the Par
Numbers without the strike-through ?

Thanks in advance

 

[Guest]

My suggestion is to "weight" the part numbers with strike thru. Add a value to a column in that row the sort by the "weighted" column. To write the code for this should not be very difficult at all if you know much VBA
You will need to assign this macro to a control button to start it manually

Dale