lehgzil
10-15-2010, 09:20 PM
hi good day to all,
i would like to ask if theres a vba code that arranges a range based on a value of a cell in it?
here is an example workbook that i am working on, though it was pre arranged from highest to lowest(without a code), i want to re arranged it automatically from lowest down to highest with a vba code. and also if i input a new model, it will rearranged again based on the value of column named SSRP.
i have a code which arranges the columns alphabetically, but i cant seem to edit it to work on this one.
hoping for suggestions...
thanks
i would like to ask if theres a vba code that arranges a range based on a value of a cell in it?
here is an example workbook that i am working on, though it was pre arranged from highest to lowest(without a code), i want to re arranged it automatically from lowest down to highest with a vba code. and also if i input a new model, it will rearranged again based on the value of column named SSRP.
i have a code which arranges the columns alphabetically, but i cant seem to edit it to work on this one.
hoping for suggestions...
thanks