I'm sure there is another way. If you want other suggestions then someone else may chip in here.

I don't have other suggestions without seeing what you are starting with. I assume you have macros to do the dependent drop down lists for instance and that has a major bearing on how the changes can be applied.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia