title: Create a folder with subfolder and hyperlink
body: <p>I want to select a cell in column A, run a macro to create a folder in a specific location with the cell value as the name.</p>
  
  <p>Within this folder, I want two folders with specific names.</p>
  
  <p>e.g.:</p>
  
  <ol>
  <li>Column A cell = P18-457</li>
  <li>select the cell and run the macro</li>
  <li>the macro will create a folder named P18-457 in C:\Users\johndo\Desktop\Quotes (this directory will not change so every time create a folder without prompting for location)</li>
  <li>within folder P18-457 create two standard folders. e.g. one called costing and the other references</li>
  <li>create a hyperlink to folder P18-457 in the spreadsheet</li>
  </ol>