I want to fill a range of cell in Excel, when another one changes.
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.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$15" Then
Call modInvoiceFiller.FillCustomerDetails
End If
End Sub
With this code, no update happens. If I run the procedure manually, it fills in the required details. Could someone please help?
Regards, Prabhu