Thank you AB33,

I would like to have Sheet1 to automatically execute the macro in modules, whenever the value in columnF get changed. I found a piece of code for this online but it is for a cell range instead of a column,

Private Sub Worksheet_Change(ByVal Target As Excel.Range) 
    If Target.Address = "$A$1" Then Process 
End Sub
I have changed the code above to reflect the macro on dtest file which is called 'test'

Private Sub Worksheet_Change(ByVal Target As Excel.Range) 
    If Target.Address = "$A$1" test 
End Sub
But I'm not sure about the syntax to use for setting up the columnf as range... please help. Thanks