Auto sort with macro

[magman1984]

Hi

I wonder how I can auto sort column O and P from smallest to largest using macro. Worth to mention is that there is formulas in P1, P2, P3 etc..

There is really no need for opening attachment.

My columns are basicly like this.

Please Login or Register  to view this content.

I want to sort both columns based on P from smallest to largest

Attachment 148600

[magman1984]

Fixed it by recording a macro

Please Login or Register  to view this content.