Run Macro when Cell Input changes

Grumpy_Old_Duffer

I have a Module macro called 'Sub Copy_Paste() and I want this to automatically operate everytime there is a new input made in any cell in the range Q5:U27 on a worksheet called "Updates", which I have given a named range to of "DataChanges".

What 'Private Sub' code do I need for the "Updates" Worksheet 'Module'?

spotter

This should do it. Copy and paste the following code into the Worksheet_Change event of your Updates sheet:

If Not Application.Intersect(Target, Range("DataChanges")) Is Nothing Then
Copy_Paste
End If