Have you considered using 'dependant' DV lists, where user selects
1st column and this determines what appears in the 2nd column's DV,
..and so on?
For example...
http://www.contextures.com/xlDataVal02.html
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus