Hi guys,

I am looking for a VBA code to copy a specific range from my current Excel worksheet into a new Excel workbook. Some requirements:


- xlsx format
- Range (A1:K83) from sheet 3
- I want the "Save as" window to open when I run the macro so I can choose the location for myself
- I want the file name to be the same as cell A1 on sheet 1 in my current workbook
- I want the values to be pasted to start in cell A1 in the new worksheet
- I only want to copy the values but still want the formatting to be the same in the new workbook (colours, column with etc.)

Would love some help with this guys!

Thank you in advance!