VBA to sort data and extra line between departments

[Damo10]

Hi,

I have a sheet that I am creating that has department numbers in column C and names in column B what I would like to do is have a macro to sort the data in columns B:DL by department number then by name but after each department add an extra line in so that they are spaced out.

Can anyone help with this is I cant see a way of doing it with the normal sort?

Regards,

 

[Damo10]

Perfect, thank you so much for your help

 

[Fluff]

Glad to help & thanks for the feedback