title: VBA to create new sheet with file name using save dialogue box and save as CSV format
body: <p>My requirement is that I am having a sheet with some data and a button which has to perform below said task.</p>
  
  <p>Task is that once button is clicked it has to ask for file name and location to be save to the new sheet in csv format and the data in the active sheet has to be copied and pasted in a new sheet and name of new sheet should be the name given for file to save in CSV format.</p>
  
  <p>Can anyone please help on this?</p>