Sort Macro

[kronik]

So..

I would like to make a macro that will do a number of things with one-click:

1. Automatically fill down a range of rows with a formula; the number of rows to fill down are the number of rows there are in the A column.

2. Sort the newly created column/range with expanded selection for all columns.

3. Either clear the row or these calculations could take place in a hidden column.

I received some assistance over at VBAX.. the code for the formula is as follows :

Please Login or Register  to view this content.

Then the formula using this function is

Please Login or Register  to view this content.

The sample data for this is found attached. Column E is the desired result from the sort.