Auto Sort then fill table

[danno8804]

I am trying to find a way to auto sort (alpha numericaly) a column of data then have it auto populate into specific cells. in the attached sheet it shows that i would paste the data in column M starting at M5. I would like the data to sort then autopopulate the box in A5 to I29. So cell A5 would have the top of my sorted data, then A6 would have the second and so on. 6A would have the 10th in the list of the data and so on.

[Crooza]

I'd put this formula in A5 and drag across and down

Please Login or Register  to view this content.

You'll need a macro to autosort the column of data but it is pretty quick to autosort 'manually' using the sort tool.

Ps I've done it according to your example being B5 has the second, C5 has the third etc not how you described it in your post.