Help needed: Code for sorting table by date

[ianwall]

I'm in the process of updating my team's planning spreadsheet. There's macro code in there I'm trying to make universal, so I don't have to create a new macro for every team member. Could someone please advise on how to change this so that every instance of the individual's name ('John' in this example), now just refers to a cell (which will contain the individuals name)?

Please Login or Register  to view this content.

[Stormin']

Try:

Please Login or Register  to view this content.

and call with

Please Login or Register  to view this content.

[ianwall]

Thanks! I managed to adapt it to get what I needed

Please Login or Register  to view this content.

[Stormin']

Don't use "NAME" as a variable, it is a reserved word. Try "strNAME" or something like that. Glad you got it working

---

If that takes care of your original question, please select Thread Tools from the menu link above to mark this thread as SOLVED.
To say thanks to the user(s) who contributed towards the solution, you can use the "Add Reputation" button on their helpful post(s).
Thanks!