It worked great, and
your suggestion was interesting with a few techniques I wasn't aware of. But
after much thought I realized that it was getting way too complicated  for Excel,
so I am going to apply the "keep it simple stupid" principle and stay away from
over-automating the app  for the users.