Can I automatically run a macro on data entry?
 

I have a table of data that I sort using a Macro. However to improve user
friendliness I would like to start this when the data in cell A20 is entered
or updated. IS this possible?

Can I automatically run a macro on data entry?
 

Yes, by using worksheet_change as follows;
Sub worksheet_change(ByVal target As Range)

If Not Intersect(cell, Range("A20")) Is Nothing Then
'Call your sort macro
End If

End Sub
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Deena" wrote:

I have a table of data that I sort using a Macro. However to improve user
friendliness I would like to start this when the data in cell A20 is entered
or updated. IS this possible?