PDA

View Full Version : Solved: Sorting Issues.



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.

Aussiebear
01-21-2013, 03:11 PM
Rather than nominating a set range ("K3:K4000" I think it was), within the code, try naming the individual ranges and making them dynamic.