trying to fix the code for sorting on the last column of every sheet the sorting on rows to be done at Rows 3:20 & 22:32.
Found the below code but I am unable to incorporate my desired rows in it. unable to crack how to define the rows in the below code.
image.jpg
Please Login or Register to view this content.
Last edited by tabkaz; 10-20-2021 at 06:49 AM. Reason: sample data
Will the rows that need sorting always be the same across all sheets?
Will the last column be the same on each sheet?
BSB
Rows will be the same but the last column will change as per the data.
Without a sample workbook it's difficult to test but give this a try.
BSBPlease Login or Register to view this content.
Thanks, it works,
it's working fine for sorting in ascending order, what to add if I have sorted in descending order for all the sheets?
Last edited by tabkaz; 10-21-2021 at 02:11 AM.
Happy to help
BSB
it's working fine for sorting in ascending order, what to add if I have to sort in descending order for all the sheets?
Try this:
BSBPlease Login or Register to view this content.
Last edited by BadlySpelledBuoy; 10-21-2021 at 02:29 AM.
have adjusted the code for sorting in descending order,
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks