title: Excel VBA - Multiple cell update based on a change in ONE cell
body: <p>I want to fill a range of cell in Excel, when another one changes. </p>
  
  <p>I have a macro which can retrieve customer details from another master workbook (WB2), based on the project number. Project numbers are in WB1 as a list. As and when user selects a project number from WB1, I need to fill cells in the range of H9:H15 (in WB1) with customer details. I am using worksheet_change event to trigger this. </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Address = "$A$15" Then
          Call modInvoiceFiller.FillCustomerDetails
      End If
  End Sub
  </code></pre>
  
  <p>With this code, no update happens. If I run the procedure manually, it fills in the required details. Could someone please help?</p>
  
  <p>Regards,
  Prabhu</p>