Thanks in advance to everyone. I have the following code that allows me to select a list of names and post to a new range. It works well but my first pass was to just recreate code X times and change the selection criteria called REG to XXX and also change the variable to paste the selection...