I think I figured it out. I had included (ByVal Target As Range) in the sub headers for the "Assignment" and "StatusUpdate" routines which wasn't required. Thanks for your help Hui. I really appreaciate it.
Thanks for replying Hui,
I apologize for not being clear and specific about my requirements earlier. Here's a brief overview of what I would like to achieve:
If a cell in column P changes, do Action 1
If a cell in column L changes, do Action 2
I've made two separate subs for Actions 1 & 2...