![]() |
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