Printable View
Good Morning Pual Sir,
Then what I do now? I have only basic knowledge of VBA. Can you put code in above my latest sheet (Stocks Sorting_3.xlsm) then sorting data asc & des order in each block. currently there are more than 20 sector/block/ranges for sorting as asc & des order in each set.if you done above 3 sector for sorting then remaining I will do (only will ranges change of each block).
Attachment 23932
1. There as a space after the worksheet name "Screener " -- I fixed
2. If you double click the marker cells, the block of data will sort
Lastly You done it Sir,exactly what I want?.
but small issue there are more than 500 rows.All block sort well & nice but between 500 rows there 2 block/set which is not asc & des order sort by double click,why I dont know but other 20 block/set properly asc & des order sort by double click.can you give me suggestion why not sorting.
Thanks again sir for your valuable effort for me.
Because your data is very formatted, it is necessary that you make certain that you follow your current format for each category, so I suggest you check the structure of any data that does not sort correctly
Attachment 23940
One category had an extra row that caused data to sort incorrectly
Attachment 23939
I fixed that in the attachment
Awesome and unbelievable, it was more than my expectation. I got my mistake & now sorting is very very correctly.
You are Great Paul Sir. Thank you very much again. I keep this work in mind for my future work,very useful sir:clap::clap::bow:
It's Great output for this Group & me also.