Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I'm trying to create a massive select/sort/insert row/auto sum groups macro button and was wondering if anyone could help or point me in the right direction
<o
></o
>
basically I have a table with a "store number" i.e. 0101,0102, 0103....ect from A3 to A20 (there's more but just for explanation sake). in column B3 it displays how many cartons to send to that store. in column C3 is shows my sort criteria.<o
></o
>
at first everything needs to be sorted by column A (which is the way it always is) but I would like to sort it by column C, this much I have an idea about I am using -:<o
></o
>
Range("a3:c20").Sort Key1:=Range("c3:c20")<o
></o
>
after its been sorted I would like to then create two new blank rows under each sort criteria (later to add in a auto sum for column B)<o
></o
>
here are some quick pics of before and after
http://img535.imageshack.us/img535/5779/unsorted.png
and
http://img96.imageshack.us/img96/8169/sortedandformated.png
any help would be awsome,
thank you,
Ray
I'm trying to create a massive select/sort/insert row/auto sum groups macro button and was wondering if anyone could help or point me in the right direction
basically I have a table with a "store number" i.e. 0101,0102, 0103....ect from A3 to A20 (there's more but just for explanation sake). in column B3 it displays how many cartons to send to that store. in column C3 is shows my sort criteria.<o
at first everything needs to be sorted by column A (which is the way it always is) but I would like to sort it by column C, this much I have an idea about I am using -:<o
Range("a3:c20").Sort Key1:=Range("c3:c20")<o
after its been sorted I would like to then create two new blank rows under each sort criteria (later to add in a auto sum for column B)<o
here are some quick pics of before and after
http://img535.imageshack.us/img535/5779/unsorted.png
and
http://img96.imageshack.us/img96/8169/sortedandformated.png
any help would be awsome,
thank you,
Ray