Macros help - when cell marked with "X"

New to macros here. Need to create macro for this:

If column "W" cells in worksheet called "ECN" contains "X or x" when I click a button called "Complete" the contents and formatting of that row need to cut and paste into a worksheet called "Closed" and then "Closed" worksheet needs to automatically sort least to greatest based on column "A" in "Closed" worksheet.

Thanks in Advance.

Good job on the explanation:

Please Login or Register  to view this content.

Originally Posted by stnkynts

Good job on the explanation:

Please Login or Register  to view this content.

Thanks so much!