I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee