title: Excel-VBA; Copy data from excel and paste it in to a word template at different places
body: <p>I have some data in an Excel Sheet which have been pull from the master data in another sheet by the VBA. The data is showing in excel sheet in column A &amp; B.</p>
  
  <p>And I have an MS-Word template as detail below: </p>
  
  <p>“ An estimate amounting to Rs. [B1] based on approved rates for the above [B2] was sanctioned by the competent authority. Against this estimate tenders amounting to Rs. [B3] were invited vide Tender No. [B4] Dated [B5] which has opened on [B7] 
  This estimate for Rs. [B1] has been approved on [b5] ” </p>
  
  <p>I want to create a macro in the Excel by which the value of different cells of column ‘B’ be paste in template in place of respective [ ] to create a new word doc.</p>
  
  <p>Please help me.</p>