Sort Problem

[rainbowzzzzz]

Hi,

I have problem when sorting.
I want to sorting by column AA, then I just need the top 5 data.
How I do it with VBA?
You can see data and result in the attachment.

Thanx for helping me.

[bstoyano]

Hi,

You can record a macro with the built-in macro recorder for these actions. Then open the macro and refine it to suit your needs.

[rishikrsaw]

Please Login or Register  to view this content.

[rishikrsaw]

pls check the range as I took only from you sheet...

many thanks
Rishi Saw

[rainbowzzzzz]

If the range always change (data always change every month), that means i must change the macro every time i used that?

Thanx

[nilem]

Hi rainbowzzzzz,
try it

Please Login or Register  to view this content.

[rainbowzzzzz]

Hi Nilem,

It's work perfectly.

Thanx for ur help.