Macro to sort data by column B within the Location & Total rows?.

Hi,
I've been scracthing my head for days trying to do this by a macro, What I am trying to do is sort the data by column B with C-F linked to it, but leave everything else as it appears on the sheet?.

Any help greatly appreciated..

Gauges2.xlsx

Paul

You could use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Hi Antonio,
Thank you for your speedy reply, I am getting an error on this line though?..

lastRow = .Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

Cheers

Paul

I've seen the macro but it seems to run fine... see attached file.

Regards,
Antonio

Originally Posted by antoka05

I've seen the macro but it seems to run fine... see attached file.

Regards,
Antonio

The workbook I posted was a small selection of the sheet. The one you posted works fine but the macro doesn't seem to work on the full workbook?... Maybe it is me doing something wrong. The amount of gauges between departments will vary from week to week also..

Thank you in advance

Gauges.xlsm

Regards

Paul

I think I have worked it out, I am trying to run it from a personal workbook which seems to be the problem.

Paul