Save filtered range as XLSX?

[JumboCactuar]

Hi,
Im wanting to:

Filter a named range (MyRange01) by a value in H1
Save range as XLSX with H1 as filename

Loop this through values H1:H50 until blank

Example: if H1 = london
Filter Myrange01 column B by value H1
Save as an XLSX named: london.xlsx

Is this doable? I have vba to save sheets but don't know how to go about this with just a range

Any help appreciated

 

[dfsobral]

how many columns have your range?

 

[JumboCactuar]

It has 10 columns (A:J)