Exporting a range to a New Excel Sheet

[Jhankins]

Hello,

I have a sheet like

x y z
1 2
2 2
3 3

I wish to export columns y and z (i.e range) to a new excel spreadsheet with the user able to pick a filename and location via a sheet button function

any idea's