Data Using Double Click on Header but multiple range

[Paul_Hossler]

Sir,It only work on Banks sector (Row 34).Not work on Auto (Row 22) & Auto Ancillaries (Row 7) for ascending & descending order,then what I do now.

The macro sorts the three blocks A-Z by Company Name

I did not tie the macro into any double click events

What VERY SPECIFICALLY did you want, since I'm must have misunderstood

For example,

1. Double Click J6 and sort just "Auto Ancillaries" by column J High to Low, then Double click J6 again and sort just "Auto Ancillaries" by column J Low to High?

or

2. Double Click J6 and sort all 3 block3 by column J High to Low within each block, then Double click J6 again and sort all 3 blocks by their column J Low to High?

or

3. Double Click any Row 6 column header and sort all 3 blocks by that column High to Low within each block, then Double click J6 again and sort all 3 blocks by their column J Low to High?

or

4. Somethng else?


You mentioned column header and Row


Before

Before.JPG

After sorting by Company Name
After.JPG