Change column width in different columns

Hi all,

I have a worksheet called "Location Matrix" which is generated based on data on other sheets (removed for redaction).

Ultimately I am looking to change the width of the columns on the left (Columns B:J) to a width of 4 - the header of the cell in row 1 for these columns will be "Active"

AND

change the width of the columns on the right (Columns K:S) to a width of 45 - the header of the cell in row 1 for these columns will be "Location"

However, the number of columns needs to be variable based on the number of mobiles. So the example attached is for 9 mobiles, so there is 9 columns for "Active" and then 9 for "Location" - but obviously if there is only 2 mobiles then "Active" will cover just columns B&C and then "Location" will just cover columns D & E.

Anyone have any ideas to do this?

Many thanks,

Chris

Excellent, thank you so much!

Just had a thought with this. Is there a way to change the font in a similar way too? I.e. "Active" font size 8 and "Location" font size 10.

Cheers,

Chris

Thank you