Hello,

Please describe what you have in all the referenced areas (some sample
data).

CUrrently I can only guess that you might need to repeat all states in
cranetest1!B:B with empty corresponding cells in cranetest1!Q:Q (but
this is sort of a wild guess I admit).

Regards,
Bernd