Combining several small macros into one large one AND Conditional/Sorting Macro Issues

Macro Help.xlsm

Hi,

Hopefully, this will be my last time bother the board with the project. So, I create several small macro each executing a specific task (i.e. formatting, applying conditionals based on a formula, sorting, etc.). I want to combine them into one large macro. I tried to 'call' the small ones into a large one, but it didn't work. Then, I tried to copy past all the language into a new module (removing all the subs and ends), but that didn't work.

Each small macro works well, except the sort (which I can't figure out why, since it is such a simple sort and the VBA was created with start, record steps, stop), when I run them one at a time. Also, is it not possible to use a VBA for sorting and conditional formatting that uses a formula? Yet, i am sure the answer is just me.

Either way, I've attached a sample with raw data, what is should look & my errors.

I think, not sure, the issue you are referring to is the sample attached. Seems you may not be able to see all the Macro. So, I added more tabs/worksheet with the VBA language for each mini macro and ones for my two attempts at combining the mini macros into a big one. In neither attempt, did I receive a code breaks error. I did include screen prints of the error I did get on the Error tab/worksheet of the attache workbook.

Macro Help.xlsm Here's the revised XLSM

How do I merge it? All my attempts have failed. What am in missing that is causing the errors (on the error worksheet) to pop up? Additionally, when attempting to create a simple sort (1st by m, then by I, then B & last C) macro (which I am doing by hitting record in the developer tab executing the steps and hitting stop), it won't work. Do I need to use some sort of formula or exclude it from the macro altogether as it cannot be done? When executing the steps to create the macro, I can see the proper results. Yet, not so much when I run the macro.

I clicked the link provided, but none of the header matched the issue I am having. I am pretty new at this, this my 1st macro. It could be I just don't understand it, which is why I came here.

Appreciate the link. Hopefully, someone will review this thread and provide a resolution soon. Thanks again and have a great night

I fixed it on my own, using the 'call' macro method