All

I have a warehouse with 8000 locations of which 3000 have products in. These
are spread throughout the warehouse leaving lots of gaps. I am about to start
to take more products and need to replan the layout of existing products at
the same time. I will have a list of the existing products, by 12 digit
product code, existing locaction, AA123 format, and new locaction in the same
format.

What I need to do is move current products to their new location if it is
empty. I know how to do a simple "if this target location is included in the
list of occupied locations skip to next number and continue to the end of the
list". My problem is that I want it to restart at the beginning again
recognising that some of the target locations will have been freed up by the
first pass through the list.

The end result I would like is a list of product moves, in sequence, to move
existing products and incorporate the new lines.

Any ideas?