I am attempting to set up a macro that takes from one list and assigns to
another list values that meet certain criteria. Once I take a value from
list A and assign it to a cell in list B, I don't want that value to be
available for use again. For example, if I have a list of a bunch of
zipcodes that end in ---01 and I am making a list that must end in that zip,
how do I make sure that if I use a zip in cell one, it is no longer
available to be "picked" for cell 2 or cell 3, etc. (I may not need all the
possible zips ending in ---01) I hope someone can make sense of this. Thanks