Data Using Double Click on Header but multiple range

[Paul_Hossler]

Here I attached another excel sheet for reference your (Sorting Data Using Double Click on Header).

But it also sorting whole all column in data range & I want each block/range sorting as asc & des order.sort_table_by_double_clicking.xls

I know how to sort by double clicking on a header

Going by your other example it seems you wanted to sort by these columns the data in just the block (Auto, etc.) on a block by block basis

Capture.JPG


Are you now saying that

if you double click J7, then

you'd like rows 9:45 sorted by J9:J45 AND

rows 49:50 sorted by J49:J50 AND

rows 55:78 sorted by J55:J78

ALL AT ONCE?????

If you double click any of the blue cells in row7, then in the newerest attachment all the data groups will be sorted

If that's NOT what you want, then I really have no idea, and will need a VERY SPECIFIC EXAMPLE, not just the same words repeated or workbooks that do not seem to have anything to do with the first request