Custom Sort looping through worksheets and workbook

Hi Guys,

I have recorded the following Macro to sort columns but need to make some modifications to it so it does what I need to achieve.

I am looking for a code that will sort columns B,C,D based on data in column B starting at row 4 (column B can have different number of rows on different worksheets) so I would like the code to find last row of column B

Also the data that requires sorting repeats every 3 columns so I need it to loop through each sheet until the last column. (eg. E,F,G based on column E H,I,J based on column H etc.) all starting at row 4

Please Login or Register  to view this content.

Thanks for any help.

Hi Bernie,

That is exactly what I was looking for. You have my life a whole lot easier.

Many thanks