VBA code for sorting

[tink_]

Hi i`ve been trying to create a VBA code for sorting the data in sheet1 but unfortunately it does not work. I have also tried to create a macro but didnt work also. Help is much appreaciated. Thank you in advance.

Please see the attachement.


tink_

[royUK]

Your data won't sort with or without VBA. To use sort the data must be in a Table with no completely empty columns or rows. Then use the Macro Recorder to get your code.

[tink_]

hi roy. Thank you for the advice. So there is no way that i can sort the data in sheet1. Is there any way that i can sort them automatically through VBA code? Because every month 1row of data is added in sheet 1. I hope you can help me. Thank you in advance.


tink_

[FrankBoston]

Please Login or Register  to view this content.