Private Sub Worksheet_Change(ByVal Target As Range) issue in VBA

Hello All,

I have excel file where in I have included 2 logics for Private Sub Worksheet_Change(ByVal Target As Range).

In sheet1, we have cell K4 which is ERP and this is drop down. Once we select value from the drop down, it should display message to clear all the details. Once the details are cleared, then we should select values based on the ERP selected which is col J. Col J is again a drop-down which gives source CoCo values for the ERP selected. These source and Target values are in sheet 2.

In my code, I have the logic to clear the values upon ERP selection and to populate target values based on source are in the same block

Private Sub Worksheet_Change(ByVal Target As Range)

Not sure, if this is causing issue in clearing the values when selecting ERPs. Also, while populate target value which is the second section of the code, I am referring to cell K4.

This is just for Coco. I need to replicate the same for other fields like Acct as well. If I include the logic for all the columns in Worksheet_Change and try to select ERP, then the file just hangs.