orcas
01-21-2013, 06:26 AM
Hello guys,
I'm having a little issue I'm hoping someone could help with.
The attached excel file contain different tables on different sheets. These tables are the portions colored in green.
I have written a code to go through each spreadsheet and sort the tables in ascending order on column K. The portions colored in blue are not to be sorted.
What i will like to be able to achieve if possible, is to make individual tables (i.e the green colored portions) really flexible so that when i insert additional rows, i can still sort them without having to modify portions of my code.
Any help received from you will be greatly appreciated.
I'm having a little issue I'm hoping someone could help with.
The attached excel file contain different tables on different sheets. These tables are the portions colored in green.
I have written a code to go through each spreadsheet and sort the tables in ascending order on column K. The portions colored in blue are not to be sorted.
What i will like to be able to achieve if possible, is to make individual tables (i.e the green colored portions) really flexible so that when i insert additional rows, i can still sort them without having to modify portions of my code.
Any help received from you will be greatly appreciated.