Code Writing

[PG2159]

Propose I use excel for module management. And I wanted to write and excel function to better assist my needs, and I wanted that code to do these functions? in this order? Thanks.

B8-B60
I want you to sort from smallest to largest.

First
C, D, E, F
I want you to sort your response, but with don't break away from B,

B must always sort with increasing number
C must sort in increasing number, still attached to D, E, F.

once done, color ever 4 row(horizontal) different color, with a bold line running horizontally at the 12 following row

[Engineer Cat]

I sent to this to my wife who's an excel guru. She thinks what you are trying to do can be accomplished by the following steps.

In main excel screen under home tab, all the way to right choose the sort and filter drop down menu (AZ icon)

Choose custom sort; window opens

Select the main criteria for your sorting

Then when you want to select your secondary criteria, click add level within that window

You will see next to the main criteria, it says "sort by" and then for your secondary criteria, it says "then by"

You can continue adding levels and criteria as needed

6452

[PG2159]

Outstanding.