Arrange in sequence order order whith selected filter

**MAKEXAN12** · 05-09-2013, 03:34 AM

Is there any way to arrange in sequence order (for example a001,a002,a003...a030) automatically when i have a selected value in filter ?

in atachment book i want to sequence arrange a001,a002.....a030 whith selected filter value 2.

Thanks !

**oeldere** · 05-09-2013, 03:48 AM

choose the range you want to sort.

then you can sort on the filtered data on column A (acending or decending).

**MAKEXAN12** · 05-09-2013, 05:20 AM

Thanks for your advice,

I don’t won’t to sort the column but i want named automatically the empty cells with the sequence order (a003, a004, a005….a030)

**oeldere** · 05-09-2013, 05:26 AM

but i won’t named (you will or you won't)?

You get better help if you add the desired result in your excel file.

**MAKEXAN12** · 05-09-2013, 05:36 AM

sorry i corrected : "but i won’t named"

**oeldere** · 05-09-2013, 05:40 AM

I think it will be possible with VBA.

But you will only want to autofill the (filterered onces?) => in your excample 2.

As already said, please add the desired result in your file.

**MAKEXAN12** · 05-09-2013, 06:09 AM

The desired data is in the new file

**ARGK** · 05-09-2013, 06:24 AM

Hi
In your example, when you select a filter your data is ALREADY sorted!!!!! Do you mean that data may be random and when you select a filter you want the filtered data sorted?
Tony

**MAKEXAN12** · 05-09-2013, 07:43 AM

I don’t won’t to sort the column but i want named automatically (autofill) the empty cells with the sequence order (a003, a004, a005….a030) in the first excel in the firts post (book1.xls).
If the excel file its without filter i can easily auto fill the empty cells with sequence order by drag below the first ant second line (a001,a002).
But when I selected a value in the filter doesn’t work the above rule.

"Sorry for my English is not my main language"

**oeldere** · 05-09-2013, 10:58 AM

See the attached file (the yellow cells).

You get in trouble if you want to do it that way.

If you use that on the data on filter 1 you get the same result.