Add a Sorting Code to the Original Code

[aviatecar]

Hello Gurus:

Please help me add a sorting code to the original code so that the new code will sort "Quote Summary" sheet according to column C in Descending Order after the execution of the original code.

The attached spreadsheet has been processed by the original code.
Quote History-Process Sample v.2-Part c.xlsm

Original Code:

Please Login or Register  to view this content.

Any input is appreciated,

Chris

[Leith Ross]

Hello Chris,

This macro is called by the macro you posted. It will sort the "Quote Summary" in descending value using column "C".

Original Posted Macro

Please Login or Register  to view this content.

New Macro To Sort Quote Summary

Please Login or Register  to view this content.

[aviatecar]

Dear Leith:

It is really nice to get response from you again!

The call function works like a charm and it is really convenient when I want to put multiple codes together in the future.

However, I am wondering if there is a way to actually combine these two codes together into one. I thought about to simply put them together but I worried about that the original code may include the sorting code for every loop. Which make the combined code very inefficient.

Is there a something that I can used to make sure the sorting code is in after the execution of all of the loops of the original code?

Thank you Leith!

Chris

[Leith Ross]

Hello Chris,

Here is the macro with the sorting routine as a single macro.

Please Login or Register  to view this content.

[aviatecar]

This is Great! Thank you Leith!

[Leith Ross]

Hello Chris,

You're welcome.