I created a validaton, it should be in column b only upto the last row of
data in col a, and the amount of rows with data in col a will change all the
time, what should I do? Do I have to delete and recreate the location every
time, if so then how? thanks in advance!