Sorting and Summing

[rizmomin]

Attached is the excel sheet for referance

This is what i am looking for:

1. Every month data will be added ...Feb-08 will be added in Column AC.
Cell C4 thru C101 is the sum(D4..AB4) and similarly Sum(D101..AB101).
I now manually have to change the formula to sum(D4..AC4)..and so on.
i would like to see if there is better way to handling this to avoid changing manually every month.

2. I would like a Macro to sort Ascending/Descending by asking "Which column would i like to sort"...

Please help....as always help is greatly appreicated...


Please let me know if you have any questions...

Riz Momin

[ChemistB]

As far as the Summing in Column C goes, why can't you have it SUM (D4:IV4) or some other column way out there? If you are graphing these, and need to have dynamic ranges, let me know and I'll describe formulas (Defined Names) for dynamic ranges but I think it's overkill here.

I'm not proficient enough with VBA to coach you there but it's definitely feasible.

ChemistB

[ChemistB]

Okay, I cheated a little by using a FORMs combobox for the user to choose a column and then click on the button to autosort but here's my stab at it. Sheet 2 can be hidden so people don't mess with it.

My macro code is as follows;

Please Login or Register  to view this content.

ChemistB

[rizmomin]

Thank a lot...this works but 1 small request...
i needed to sort by Column A and B also so i would need that option

Please help

Thank U

Riz Momin