VBA autosort

**danzing87** · 12-06-2010, 11:49 PM

Hi I have a question regarding autosort under VBA coding.

If let's say, I have a rows of data where one specific column categorised them under A, B, C, etc (for simplicity).

How do I type a VBA code where in the case:
If row i and column 1 = "A", then all of these A category will auto-sort themselves in ascending order?

Many thanks

**danzing87** · 12-07-2010, 03:25 AM

Is it impossible to be done under VBA macro?

**TMS** · 12-07-2010, 04:04 AM

It is not clear to me from your post what it is you need to do or what you are doing it with.

I suggest that you post a sample workbook with some typical data and a little clarification of the sequence of events, input and desired output.

Regards

**danzing87** · 12-07-2010, 05:06 AM

okay, i've created a sample workbook. In it, I've simplify the scenario.

Suppose I have made an entry of country China under the last row of "Asia" section.

How do I have a VBA code which auto sort only those countries which are under Asia (in ascending alphabetical order)?

In addition, I want the auto-sorting to not include column C but only column A, B and D.

Many thanks