Need help for macro to automatically sort every 5 rows

Hello,

I am trying to make a macro that will sort every 5 rows by column b ascending.
So if I were to have 15 rows of data, it would sort rows 1-5 ascending by column B, then rows 6-10 by Column B, then rows 7-15...all the way until the last row of data.

Thanks,
Excel Beginner

Try this.

Please Login or Register  to view this content.