Run Two Worksheet Change Macros With Different Target Cells

Hello,

I am needing to run two rules on the same sheet using VBA.

The example sheet is a simplified version of the actual sheet.

The first thing I need to happen is, when a value in column I is changed to "Complete" the line of data moves over to the sheet named "Archive".
The second thing I need to happen, as a separate event, is, when the value in column H is changed the whole table is put into ascending order based on the number shown in the cell in column H.

The two commands on the sheet work independently on separate sheets but I cannot get them to work when added to the same sheet.
I know I cannot use the "Worksheet_Change" name for both as it throws up the "ambiguous" error but I cannot get the macros to kick in automatically when even when I rename the second command.

I'm not sure if what I am trying to achieve is impossible but I have been asked to see if I can get it working and it is seriously stretching my very limited knowledge of VBA.

Any help or advice would be greatly appreciated!

Many thanks!

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.