ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing already used values (https://www.excelbanter.com/excel-programming/316259-removing-already-used-values.html)

Jim Brass

Removing already used values
 
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




All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com